UnknownPlayer Posted November 9, 2011 Share Posted November 9, 2011 I'm using InnoDB becouse i need it for relations, i mean foreign key, but i was searching for difference about these 2, and i found that myisam is faster. So i am confused if my website will work fine with innodb or i should use some other for foreign key ? Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/ Share on other sites More sharing options...
fenway Posted November 10, 2011 Share Posted November 10, 2011 That depends on how much of your data you want back if it crashes. Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/#findComment-1286868 Share on other sites More sharing options...
UnknownPlayer Posted November 10, 2011 Author Share Posted November 10, 2011 If i have large db, with lots of datas ? Is there other solution for this, foreign key ? Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/#findComment-1287220 Share on other sites More sharing options...
fenway Posted November 11, 2011 Share Posted November 11, 2011 That doesn't answer the question. Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/#findComment-1287341 Share on other sites More sharing options...
The Little Guy Posted November 11, 2011 Share Posted November 11, 2011 It also depends on what version of MySQL you are running, the has been a HUGE improvement in InnoDB in Mysql 5.5 in selecting and inserting. http://vbtechsupport.com/657/ Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/#findComment-1287368 Share on other sites More sharing options...
UnknownPlayer Posted November 20, 2011 Author Share Posted November 20, 2011 That doesn't answer the question. You are here to help. Anyway, you didnt ask anything, i dont see queston mark on end, so.. It also depends on what version of MySQL you are running, the has been a HUGE improvement in InnoDB in Mysql 5.5 in selecting and inserting. http://vbtechsupport.com/657/ Server version: 5.0.91-log I saw on web that innodb is slow, but i need it for this key. Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/#findComment-1289699 Share on other sites More sharing options...
fenway Posted November 20, 2011 Share Posted November 20, 2011 That doesn't answer the question. You are here to help. Anyway, you didnt ask anything, i dont see queston mark on end, so.. My question was :"That depends on how much of your data you want back if it crashes." Link to comment https://forums.phpfreaks.com/topic/250808-innodb-or-myisam/#findComment-1289736 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.