Database Queries


I am looking for some guidlines on what is an acceptable ammount of database queries. The site I am building for my place of employment is done with Joomla!, and I want to make sure that I am not bogging the server with too many queries from modules etc.
The site has not officially gone live yet, however, I noticed quite a bit of queries just from testing the site. I am a little worried about how much dabase usage is going to increase once we get some visitors/user.
I am still new to mySQL, and I just need some pointers on what is accetable usage.



As with CPU usage, DreamHost really doesn’t have a limit:,PHP&Databases/MySQL/_Conueries#How_many_conueries_am_I_allowed_per_month.3F


If you are looking for an “in general” figure, there isn’t really one to give. Sites have different uses and needs, so the number of queries a given site uses varies greatly. If it is largely a Joomla page, I wouldn’t anticipate any trouble.

Check out Gordaen’s Knowledge, the blog, and the MR2 page.