neo777ph Posted July 27, 2007 Share Posted July 27, 2007 1.)what are the pros and cons between MyISAM vs InnoDB? 2.)what is the difference between Collation latin1_swedish_ci and utf8? thank you. Link to comment https://forums.phpfreaks.com/topic/62008-myisam-vs-innodb-and-collation-latin1_swedish_ci-and-utf8/ Share on other sites More sharing options...
hvle Posted July 27, 2007 Share Posted July 27, 2007 MyISAM table allow fast query and insert however it is not transaction safe. InnoDB is not as fast but it guarantee transaction safe. Link to comment https://forums.phpfreaks.com/topic/62008-myisam-vs-innodb-and-collation-latin1_swedish_ci-and-utf8/#findComment-308736 Share on other sites More sharing options...
Foser Posted July 27, 2007 Share Posted July 27, 2007 Although you can store more data in MyISAM but we wont need more than 50tb for one db hopefully Link to comment https://forums.phpfreaks.com/topic/62008-myisam-vs-innodb-and-collation-latin1_swedish_ci-and-utf8/#findComment-308804 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.