Some people in the APC mailing list have said that mysql blows up at around
200-300 queries a second.
http://lists.communityconnect.com/pipermail/apc-cache/2001-April/000611.html
Phil Jackson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Some good advice
Some good advice already given, and I quite agree. MySQL is no light-weight -
comparable to MS SQLServer and Oracle in performance. Also, running the DB on a
dedicated DB server may buy some performance. If you must check out SQLServer, then
http://www.sqlteam.com is a good place to start.
Your DB needs sound more hardware intensive than anything. Your queries
sound simple and I would bet you would never need to use anything but
mysql. Also keep in mind that mysql/php/apache etc run on more than just
PC's. There is some serious hardware out there that can handle
If anyone has had some experience with upgrading as your operations grow,
I'd appreciate if you could answer ANY of the following questions:
Did you say M$.. yuck.. if you think you need something else then MySQL you
could take a look at PostgreSQL.. It's good, it's free and it doesn't have