Forum : Explain the difference between MyISAM Static and MyISAM Dynamic. ?
Brief description  about Online courses   join in Online courses
View prabeen  patra 's Profile

Explain the difference between MyISAM Static and MyISAM Dynamic. ?

Explain the difference between MyISAM Static and MyISAM Dynamic.??
Asked by prabeen patra | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Prabeen,
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.
Mar 18, 2010