Demaestro
msg:4175017 | 9:38 pm on Jul 22, 2010 (gmt 0) |
I would look at turning on query caching.
I'm not sure what DB you are using but most have built in query caching. Basically it knows the result of a query and it knows if a table that a query retrieves info from has been updated. If it hasn't then instead of executing the query it just returns the cached results.
It works quite well. I have seen turning it on result in great performance enhancements for sites performing lots of DB hits per page load.
This is by far the easiest way to start if your DB has this built in.
|
smithaa02
msg:4175341 | 1:41 pm on Jul 23, 2010 (gmt 0) |
Thanks for the information...I didn't know that. How scalable is query caching? I would probably have a 1000+ pages with significant content...is this something query caching could handle or would I have to tweak the settings to allow each page to be cached?
|
Demaestro
msg:4175403 | 4:19 pm on Jul 23, 2010 (gmt 0) |
It doesn't matter how many pages there are. If you are worried about load it has more to do with how many times a table is updated while lots of queries are being executed.
Do a search for the name of your database and version and the words 'query caching'. Try to find something from the actual manual and read up on it.
As always with any change of this size I recommend creating a copy of the database and the site and make the changes and do your tweaking there... then once you are feeling safe switch it to the live site.
If you have more questions post back.
|
|
