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 ? Quote Link to comment 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. Quote Link to comment 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 ? Quote Link to comment Share on other sites More sharing options...
fenway Posted November 11, 2011 Share Posted November 11, 2011 That doesn't answer the question. Quote Link to comment 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/ Quote Link to comment 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. Quote Link to comment 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." Quote Link to comment 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.