Jump to content

NFR NFC 2016 - The Friendly Thread for Lovely People


jeffie
 Share

Recommended Posts

12 hours ago, eFestivals said:

isn't it time to start a new thread, and let this one die away...?

(I prefer it that way - big threads like this one end up having an effect on server performance).

was nice to meet you old son even tho it was very short lol ....i agree kill this one ..it didnt do its job anyway lol

Link to comment
Share on other sites

  • Replies 19.4k
  • Created
  • Last Reply

Top Posters In This Topic

  • lucyginger

    1743

  • mr gumby

    1963

  • thurlow84

    2205

  • A Guy Called Matt

    1649

Top Posters In This Topic

Posted Images

On 11/07/2016 at 9:16 AM, stuartbert two hats said:

That's interesting. Was the headliner thread last year causing you issues?  I don't remember that page loading noticeably more slowly - how did the problems manifest themselves?

Firstly, I'll say it's probably less of an issue with v4 of the forums than it was in the past, as they restructured many of the database tables. Changes to the database server software over the years might have improved things too.

But big tables have big indexes, and those indexes need to be written to disk now and then - and when that happens, it stalls database server activity. The only times this was ever really noticeable at the user end of things was at the busiest times (ticket day, particularly).

When a topic stops being posted in, (at an admin-defined point) that topic gets moved to an archive table, which keeps the table of active topics comparatively small, meaning that background stuff such as re-writing indexes happens much quicker (tho may not have to happen at all at the busiest times, as running out of memory to cache the tables is less likely too).

A single thread like this is by itself unlikely to cause issues, but the combined effect of many big threads like this is noticeable.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.



×
×
  • Create New...