Database Queries

Database Queries

Posted by: tjbaker
Posted on: 2006-07-06 12:37:00

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

Re: Database Queries

Posted by: sdayman
Posted on: 2006-07-06 13:10:00

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

Re: Database Queries

Posted by: gordaen
Posted on: 2006-07-06 18:09:00

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.

Tags: database queriespointersmysql