Results 1 to 3 of 3

Thread: MyISAM Static Vs MyISAM Dynamic

  1. #1
    Join Date
    Oct 2008
    Posts
    51

    MyISAM Static Vs MyISAM Dynamic

    Hello,
    please explain the Main or Technical difference between MyISAM static,and MyISAM dynamic?

  2. #2
    Join Date
    Apr 2008
    Posts
    193

    Re: MyISAM Static Vs MyISAM Dynamic

    Here are few points on which we can differentiate Two terms.
    1.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.
    2.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.But MyISAM dynamic is not capable of doing this.

  3. #3
    Join Date
    Oct 2008
    Posts
    51

    Re: MyISAM Static Vs MyISAM Dynamic

    Thanks for your reply, please mention if any other points are there.

Similar Threads

  1. Static and Dynamic RAM
    By Harpreet Gaur in forum Motherboard Processor & RAM
    Replies: 5
    Last Post: 29-01-2010, 02:31 PM
  2. Combination of static libraries in a dynamic
    By Badrunath in forum Software Development
    Replies: 3
    Last Post: 27-10-2009, 06:48 PM
  3. Differences between static and dynamic routes
    By Raffaele in forum Networking & Security
    Replies: 3
    Last Post: 21-07-2009, 10:54 PM
  4. Restore corrupted MyISAM/InnoDB tables on MySQL 5.0
    By jean-paul martell in forum Software Development
    Replies: 5
    Last Post: 14-04-2009, 09:03 AM
  5. MySQL MyISAM vs InnoDB
    By tombman in forum Software Development
    Replies: 5
    Last Post: 13-04-2009, 03:42 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,206,889.72534 seconds with 17 queries