View Single Post
Old 03-25-2009, 10:10 AM  
raymor
Confirmed User
 
Join Date: Oct 2002
Posts: 3,745
Your server admin can use some tools, such as "top", to see exactly
what on your site is causing the high load. By far the most common
cause is a PHP script running poorly designed SQL queries against
a poorly designed database. Very often, looking at MySQL's slow
query log you can find a query or two that is causing a bunch of
load. That can then be fixed by rewriting that query or two and probably
adding an appropriate index to the database.

If you have a LOT of sluggish PHP code, a simple caching system
can often be added in just a few minutes and reduce load by 90%
or more.
__________________
For historical display only. This information is not current:
support@bettercgi.com ICQ 7208627
Strongbox - The next generation in site security
Throttlebox - The next generation in bandwidth control
Clonebox - Backup and disaster recovery on steroids
raymor is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook