> Im running some benchmarking tests on mysql, postgres and interbase
> database servers.
>
> does anyone know the reasons why or know where i can find out some
> technical reasons why the mysql database server is particularly good in
> relation to the others or just by itself e.g. use of query optimisation
> or indexing etc. I'm only looking at creates, selects, inserts, update
> and delete statements.
>
> I've tried to look around for this on the net, but all i seem to get is
> a big arguement consisting of the features lacking in mysql that are in
> other databases e.g. ACID!!
Without detailed knowledge, may I suggest that you have answered your own
question.
MySQL has dumped some of the more complex features offered by other
databases in
favour of oprimising for prformance. Some of the features arequired for
ACID would probably
slow it down considerably. Isn't it nice toi have the choice - if you
really need ACID, there
are other databeses which will offer it. If you don't, you can used MySQL
and not be
burdened with the cost of it.
Alec Cawley
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
