I developed a large website for a client and in the past month we were getting a lot of traffic.
It was in a way that the server had problems handling the traffic and my client wanted to get another server to load balance the traffic between the two.
Pages on this site are generated from 10 to 25 MySQL queries and these queries are optimized but consider this, if there are 1,000 request for a page with 25 queries in a very small period of time, that would be 25,000 queries. 25,000 queries + processing them could lead to huge server loads.
So we used PHPCache to cache the results of those queries for just 1 minute, not an hour or a day, just one minute and it made a huge difference.
The difference was that we cached all 25 queries plus the time it took to process them using PHPCache and now to handle 1,000 requests we were querying the database only 1,000 times.
I think this site can easily handle 10 times more traffic now.
I'm the co-founder of
No comments yet.
RSS feed for comments on this post. TrackBack URL