i just read a benchmark on innodb.org....
http://www.innodb.com/bench.html
that says under the "innodb vs MyISAM" section...
MyISAM is the default table type used in MySQL and InnoDB is a table type
supporting transactions in MySQL. I wrote a Perl program which inserts 100
000 rows to a table with 3 integer columns and two indexes. Then another
Perl program fetches each row either through a secondary index or the
primary key. The Perl programs for each test are at the end of this web
page.
I ran the tests on a Linux 2-CPU Xeon 450 MHz. The times below are wall
clock times. The results were:
InnoDB MyISAM
------------------------------------------------------------
100 000 inserts 25 s. 40 s.
100 000 selects on
primary key 57 s. 58 s.
100 000 selects on
secondary key 68 s. 95 s.
------------------------------------------------------------
Is this true? For regular inserts that seems cool - obviously transactions
would take a little more,
but hey, why bother with MyISAM then?
dave
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
