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 Quote 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). Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.