Im running some benchmarking tests on mysql, postgres and interbase
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 noticed that Mysql is particularly good at
insertions, deletes and updates but quite poor (in relation to postgres
and interbase) at performing complex queries such as left, right, inner
joins with where clauses. Why is this?
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!!