List:MySQL on Win32« Previous MessageNext Message »
From:<jbonnett Date:March 26 2006 9:53pm
Subject:RE: MyISAM or InnoDB?
View as plain text  
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

John B.

-----Original Message-----
From: Jorge Bastos [mailto:mysql.jorge@stripped] 
Sent: Friday, 24 March 2006 10:33 PM
To: win32@stripped
Subject: Fw: MyISAM or InnoDB?

Nobody answered me :-(


----- Original Message ----- 
From: "Jorge Bastos" <mysql.jorge@stripped>
To: <win32@stripped>
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
there's any problem for the tables for the large amount of records.

Jorge Bastos 

Fw: MyISAM or InnoDB?Jorge Bastos24 Mar
  • Re: MyISAM or InnoDB?Greg Quinn24 Mar
RE: MyISAM or InnoDB?jbonnett26 Mar
  • RE: MyISAM or InnoDB?Jan Theodore Galkowski27 Mar