[EMAIL PROTECTED] writes:
>
>
> > 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
>
>
>
Hi!
Just to clear up the issue a bit.
If you wish to have ACID level of security use MySQL with BDB or
InnoDB tables.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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