Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="Twin Rose" data-source="post: 3010290" data-attributes="member: 2765">Here is what Recent Posts was doing:Loading up however many million posts on EN World, and then organizing them from newest to oldest, showing the most recent few of those.  This process was repeated for every person viewing the front page in any given few seconds, which is typically quite a few, 80% of which are "guests".  (About 8% of the total number of people online were viewing the front page at the time of this post, aproximately 125 people).The number of database connections this made was creating a situation where the system was unable to create any more connections, therefore timing people out.  Something that normally takes 1-2 seconds to load was taking 10-20.  In some areas, where multiple things are being done, that drags those on for 40, 50 or even more seconds.Reducing the number of database connections at any given moment that aren't needed is a huge part of speeding EN World up right now.  It's simply that all the connections made on any page, are multiplied by the number of people viewing it... and with news, reviews, recent posts, polls, and anything else that requires database queries on the same page multiplied by the number of people using it, it can become a huge drag.Some things can be cached - the front page doesn't list the 'newest' stuff at EN World, rather specific things that are chosen, to reduce the number of database queries needed to display it.  I'll be looking at more ways to streamline that, and create more caches, perhaps updated hourly that can bring some of these features back to the front page.It's 3 am here as I post this, and 1500 people are on.. On a tuesday night!  (or wednesday morning).  That's a huge jump from where it was a few months ago.  In the last 30 days, there's been 13 million page views, and over 1.3 million unique visitors.  That's a lot.  (Well, 31 days, it's after midnight now).  And considerably higher than it was.  We have to find ways to streamline, since there are other sites running on this server.In a perfect world, I could find a way to make it run fast AND have every possible feature, but until the upgrade is complete, there isn't a way with the amount of people online.  Many threads have cropped up of people saying "EN World is slow!"</blockquote>

Verification