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.
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 alr
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
unbelieveabl
>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