I've got a script that I've released as open source. A user recently reported to me that their host has complained that it's using too much of the server resources. He says that it occasionally jumps up to 15% memory usage, and the CPU usage up around 1.5-2.5. This is on a Celeron 2.2gHz with 512 of RAM. He reports getting around 900 unique visitors a day.
I'd like to do what I can to improve the script to make it not so heavy on server load, but am not quite sure what to do to improve it. All of the appropriate fields are indexed, and when doing queries, I always call the specific columns and don't use SELECT *. Anyone got any other suggestions?
