Re: [cobalt-users] MySQL limits- OFF TOPIC -

["Carrie Bartkowiak" <ravencarrie@xxxxxxxx>]

> How many operations can MySQL deal with simultaneously in a RaQ4  -
using
> PHP interphases?

I'm not sure of the exact number but you'll find it on the MySQL web
site. Shouldn't have anything to do with the fact that you run a RaQ4
or use PHP to interface with it - unless you're short on RAM. ;)

> When is it a good time to consider migrating to a more efficient
db -
> Oracle maybe?

That really depends. Oracle is not more efficient than MySQL in
*everything*; last time I checked the MySQL site, they were claiming
that MySQL whipped Oracle's butt on quite a number of issues.
Personally I'd say you'd have to have one huge amount of data and/or
users - and I really mean HUGE - before you'd need to leave MySQL, if
at all.

> What db's must be considered for the long term? - pref. working on
linux -

I think you've got it nailed down - MySQL and Oracle. Stay away from
anything Microsoft; but again I think you only need to migrate to
Oracle if it's a personal preference of yours OR once you start
noticing signs that the database is too big and performance is
suffering. With a carefully created database, though, it's quite
likely that you'll never hit that point with MySQL.

CarrieB