[thelist] MS-SQL vs. MySQL - was Front-end for MS-SQL?

[Katherine Spice]

Chris Johnston wrote:
> 9. Anything else you would like to share

I forgot this! MySQL isn't really an enterprise level solution. It's
very stable, and (touch wood) I've never lost data with it. Lots of high
traffic websites (slashdot) use it, and for selecting it's very fast. It
does not, however, support transactions and it rebuilds its indices
after each insert/update. The question is, how enterprise level are you?
We're happy to use MySQL (in preference to Access) for a the little
databases which are needed, but we run our major two off Oracle, because
they are "mission critical". We then have cut down copies (ie only
including the necessary data) which we mirror (at night) using custom
written Perl scripts for the website. This means we only pay licenses
for internal use.

YMMV :-)
Katherine