Change it to the more efficient MyISAM type. : MyISAM « Engine « SQL / MySQL






  1. SQL / MySQL
  2. Engine
  3. MyISAM

Change it to the more efficient MyISAM type.

     

ALTER TABLE tablename TYPE = MYISAM;








Related examples in the same category

1.MyISAM storage engine supports composite indexes that include an AUTO_INCREMENT column.
2.Change the Type of the Table (MyISAM, InnoDB)
3.Secure backup of a MyISAM database: --lock-all-tables:
4.ENGINE = {BDB | MEMORY | ISAM | INNODB | MERGE | MYISAM}
5.MYISAM engine