Database Queries


#1

Hello,

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.

Thanks

tj


#2

As with CPU usage, DreamHost really doesn’t have a limit:

http://wiki.dreamhost.com/index.php/KB_/Web_Programming/_CGI,PHP&Databases/MySQL/_Conueries#How_many_conueries_am_I_allowed_per_month.3F

-Scott


#3

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.