Xman04 wrote:
I was noticing that one of the themes displays the number of queries that are run each time a page is loaded. I was playing around with the cache features, and reduced the home page queries from 52 to around 20. Basically, I'm trying reduce the number of times that the database is accessed and reduce the resources utilized by the CPU. The goal being to minimize resource consumption, to avoid my shared server account from slowing down or locking up during traffic surges.

I have a question about this. With most shared server plans, there is a limit to concurrent MySQL user connections. My particular plan has a 15 user limit, meaning that if 16 users access the database server at the exact same time, then the 16th user will receive an error message. Ok here is my question: When a user accesses my home page, are those 20 queries considered to be occurring under one user connection? Or is there ever a situation where a set of queries (initiated by the same user) are issued through multiple connection requests? I'm hoping that isn't the case, given the limit of 15 concurrent connections.

One other question. Has anyone set a short cache (example: a 30 second cache) to their forum? I'm thinking that maybe a 30 second cache will allow me to run a somewhat busy forum, without the 15 user connection limit being a problem (at low to moderate levels of traffic). My only concern would be the lag in new posts appearing because of the 30 second cache. I'm just trying to figure out a way to squeeze as much as I can out of a shared server, before being forced to upgrade to a VPS, semi-dedicated, or dedicated server.

Dave