Explain the difference between MyISAM Static and MyISAM Dynamic. ?
By
Hi,
Can anyone explain me what is the difference between MyISAM Static and MyISAM Dynamic
Teacher SiliconIndia replied to Monday, November 23, 2009
Hi Naveen,
In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.
