To the best of my knowledge, I don't think it matters. Either table type
can handle that many records. The issues with that many records are more
likely to be having the correct indexes defined and being sensible about
the sort of queries you process. Adequate computing hardware will help
From: Jorge Bastos [mailto:mysql.jorge@stripped]
Sent: Friday, 24 March 2006 10:33 PM
Subject: Fw: MyISAM or InnoDB?
Nobody answered me :-(
----- Original Message -----
From: "Jorge Bastos" <mysql.jorge@stripped>
Sent: Wednesday, March 22, 2006 12:40 AM
Subject: MyISAM or InnoDB?
I'd like to ask a thing, with a support for a table with about 500.000 /
700.000 records and another with about 5.000.000/10.000.000
what would you sugest? MyISAM or InnoDB?
i don't need any special features that exist in InnoDB, i'm just worried
there's any problem for the tables for the large amount of records.