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
