MySQL Forums
Forum List  »  General

Re: what's the difference between MyISAM and InnoDB?
Posted by: shanmugarajan k
Date: February 23, 2005 11:50PM

Hi..
MyISAM is a default table type in MySQL. It's an improvement over the now-deprecated ISAM table type. It provides a simple tree structure for quick indexing on small tables, typicall fewer than 10,000 rows of data.
The innoDB is best while using huge tables. it is aslo fast and efficient but its the tree stucture are very large.so it's not good for smaller tables.

Options: ReplyQuote


Subject
Written By
Posted
Re: what's the difference between MyISAM and InnoDB?
February 23, 2005 11:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.