Ok. In present day, almost everybody have a web site. Actually many kind of web site is dynamic. I change my decision to mysql. (maybe later postgresql or another)
And in starting every kind of database fast and doing their job clearly. So time is past and past and past and past ……… Database will taked more data and getting slowly.
Ok. This article about myisam and innodb.
Test database 3300 unique data and i copy more and we have 217k data now. (Innodb and Myisam)
Test computer have (My old friend) 512 mb Ram, Centrino 2.0 GHZ (Pentium M). and a lot of process. (in web server we have a lot of process.)
Ok Let’s test. Not: Myisam hasn’t fulltext,index or nothing
First Test: Count to Data. (command base)
InnoDB: 15.14 second. (217536)
Myisam: 0 second (217536)
Second Test: Select * from tables limit 600,30
InnoDB: 0.14 second. (30)
Myisam: 0.06 second (30)
Third Test: Select * from tables order by RAND() limit 5;
InnoDB: 5.28 second. (5)
Myisam: 2.31 second (5)
Fourth Test: Select * from tables where column like “%yo%” limit 5;
InnoDB: 0.05 second. (5)
Myisam: 0.03 second (5)
This is done for now. Myisam id winner of speed test.
For now.
Tags: innodb, myisam, Mysql, speed test