marvinrayreyes Posted May 27, 2014 Share Posted May 27, 2014 Hi Masters, I'll be making a big ticketing program with PHP and I cant decide what data type to use. Thanks, Marvin Link to comment https://forums.phpfreaks.com/topic/288802-what-data-type-to-use-myisam-or-innodb/ Share on other sites More sharing options...
boompa Posted May 27, 2014 Share Posted May 27, 2014 Here's a good comparison article: http://www.rackspace.com/knowledge_center/article/mysql-engines-myisam-vs-innodb I would go with InnoDB for transaction and foreign key support, as well as row-level locking (if two people are editing a ticket, you don't want one overwriting the other's changes). Link to comment https://forums.phpfreaks.com/topic/288802-what-data-type-to-use-myisam-or-innodb/#findComment-1481003 Share on other sites More sharing options...
marvinrayreyes Posted May 28, 2014 Author Share Posted May 28, 2014 thanks for the reply sir. Usually I use innodb for my projects but my colleague told me to use myIsam because its faster than innodb. Link to comment https://forums.phpfreaks.com/topic/288802-what-data-type-to-use-myisam-or-innodb/#findComment-1481107 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.