Re: difference between fixed length tables MyISAM vs. ISAM

2002-05-21 Thread Benjamin Pflugmann
Hi. Just a little addition to the original e-mail: you want to try SHOW TABLE STATUS Bye, Benjamin. On Mon, May 20, 2002 at 10:08:13PM -0700, [EMAIL PROTECTED] wrote: > On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote: > > > > Hello All, > > > > I recently moved my data

Re: difference between fixed length tables MyISAM vs. ISAM

2002-05-20 Thread Jeremy Zawodny
On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote: > > Hello All, > > I recently moved my database from mysql 3.22.29 to 3.23.41, and > udated all my tables to MyISAM tables. Under ISAM, I could take the > filesize of the ISD table and divide by the record length to get the > exact n

difference between fixed length tables MyISAM vs. ISAM

2002-05-19 Thread Henry Hank
Hello All, I recently moved my database from mysql 3.22.29 to 3.23.41, and udated all my tables to MyISAM tables. Under ISAM, I could take the filesize of the ISD table and divide by the record length to get the exact number of records returned by "select count(*)" from that table (or vise-ve