Padgoi Posted July 1, 2007 Share Posted July 1, 2007 I've heard of sites that can handle like thousands of queries per second. I have no idea what's considered a lot of queries per day. Any help? Also, how long til a mysql dbase really starts conking out due to an overload of queries? And what is considered a lot of queries for one page? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
AndyB Posted July 1, 2007 Share Posted July 1, 2007 The answer to all those questions is (almost certainly) far more than you'll need for any site you ever build. Quote Link to comment Share on other sites More sharing options...
Padgoi Posted July 1, 2007 Author Share Posted July 1, 2007 thanks for the wiseass comment Andy. However, I'm the administrator of MySpace and . . . ok, just kidding. But seriously, I just finished writing a script for a site and I've received a LOT of positive feedback about it so I am interested in knowing the answer to this question. Quote Link to comment Share on other sites More sharing options...
AndyB Posted July 1, 2007 Share Posted July 1, 2007 http://www.mysql.com/why-mysql/topreasons.html Follow a few links ... http://www.mysql.com/why-mysql/case-studies/mysql_cs_utel_en.php ... handles 10,000 Requests per Second Quote Link to comment Share on other sites More sharing options...
leightr Posted July 1, 2007 Share Posted July 1, 2007 I disagree, Look at a script called phpfox.com (a myspace ripoff) It runs so many queries that the script becomes super slow..... Quote Link to comment Share on other sites More sharing options...
AndyB Posted July 1, 2007 Share Posted July 1, 2007 I disagree, Look at a script called phpfox.com (a myspace ripoff) It runs so many queries that the script becomes super slow..... And how do you know how many queries it runs? Perhaps it's running on an overloaded server; perhaps the database design is brutally inefficient; etc., etc. Just because a site is 'slow' and uses a database does not guarantee that the database server software is bad. Quote Link to comment Share on other sites More sharing options...
leightr Posted July 1, 2007 Share Posted July 1, 2007 Because I run two sites that use phpfox. I run one on a a nice VPS and another on a shared hosting. Both run super slow. After months of researching it.. and with phpfox help.. they concluded it was because they script runs over 1500+ queries. Which I believe their new release cuts that in half. Quote Link to comment Share on other sites More sharing options...
AndyB Posted July 1, 2007 Share Posted July 1, 2007 .. they concluded it was because they script runs over 1500+ queries. Which I believe their new release cuts that in half. As I observed, perhaps the database design is brutally inefficient. That certainly seems to be the case for them. What does 1550 queries mean? Per day, per second, per what? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.