[eluser]jedd[/eluser]
[quote author="Mareshal" date="1268749016"]
CodeIgniter.com has 5,152 Alexa rank, which means at least 30-50k unique visitors daily(if someone could confirm this would be ok).
[/quote]
Unique visitors or page hits? If the former, it's hard to gauge without knowing what the average number of page hits per unique visitor is.
Given there's ~ 90k seconds a day, it's not a huge load that we're talking about - even if the one SQL server attends to all aspects of the site (forum, wiki, front pages, etc).
Quote:This can cause a high load for the server, and this is why that page makes the SQL server and the CPU to "take a breath" between queries and other tasks.
Can you swim without taking a small breath every couple of seconds?
That's an interesting explanation - but I don't understand it.
If you are delaying every search result by 1 or 2 seconds (rather than every page load - which we're clearly not seeing here) it doesn't mean you have less load. it just means that your load is offset by 1 or 2 seconds - which has got to result in a nearly identical load profile for your server.
Or, if you prefer, it's like taking the same number of breaths, the same amount of air intake, the same space between breaths - just you held off taking your first breath by 2 seconds.
