RE: MyISAM or InnoDB?
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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 too. John B. -----Original Message----- From: Jorge Bastos [mailto:[email protected]] Sent: Friday, 24 March 2006 10:33 PM To: [email protected] Subject: Fw: MyISAM or InnoDB? Nobody answered me :-( Jorge ----- Original Message ----- From: "Jorge Bastos" <[email protected]> To: <[email protected]> Sent: Wednesday, March 22, 2006 12:40 AM Subject: MyISAM or InnoDB? Hi people, 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 if there's any problem for the tables for the large amount of records. Jorge Bastos -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]