Do you have any idexes on the table? What does your
mysql> show create table tbl_name \G statement look like please? Keith In theory, theory and practice are the same; in practice they are not. On Thu, 13 Apr 2006, Luke Vanderfluit wrote: > To: mysql@lists.mysql.com > From: Luke Vanderfluit <[EMAIL PROTECTED]> > Subject: innodb vs myisam > > Hi. > > I have the following myisam table: > > The table is only 32,000 rows, but over 60Megs in size. And mysql seems > to be wanting to write to that file alot, so it may well be trying to > seek all over the disk looking for the right spot all the time. > > Does innodb do a better job at keeping the file on the disk smaller? > > Does an innodb table take up less disk space than myisam? > > Is an innodb table compacter and would therefore require less disk seek > time or I/O than myisam? > > Kind regards. > Luke. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]