Jump to content


Photo

MySQL Questions


  • Please log in to reply
2 replies to this topic

#1 davidja

davidja
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 11 December 2005 - 05:18 PM

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.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 December 2005 - 02:44 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 yeago

yeago
  • Members
  • PipPip
  • Member
  • 20 posts

Posted 24 December 2005 - 06:01 PM

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.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users