Jump to content

Archived

This topic is now archived and is closed to further replies.

davidja

MySQL Questions

Recommended Posts

i get the felling that the more querys you do on a database the slower your site will run. with this in mind i would like to ask how many querys per minute can you do on just a standard server before your site starts to slow down.

Share this post


Link to post
Share on other sites

This is totally dependent on the nature of the queries that you run, as well as the actual hardware that's running the server. In general, MySQL scales quite well under heavy read load, as long as the actual SELECT statements you're executing aren't 5-table joins that return 1000s of records. I can't give you an exact number, but under you have 1000s of users on the site all the time, I wouldn't worry about it.

Share this post


Link to post
Share on other sites

Sure, not to mention piss off your system administrator.

 

Don't go query crazy I guess. If you make your queries smart, you'll get everything you need and everything you don't need in one fell swoop. You ought to post some of your practices.

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.