brianlange Posted September 16, 2010 Share Posted September 16, 2010 I am loading about 750k records every night into a table. Should this table be innodb or myisam? I am using the load data from file option for inserting the records. The records do not get written to once the table is loaded. Quote Link to comment https://forums.phpfreaks.com/topic/213591-innodb-or-myisam-tables/ Share on other sites More sharing options...
Mchl Posted September 16, 2010 Share Posted September 16, 2010 What you do with this data afterwards? Quote Link to comment https://forums.phpfreaks.com/topic/213591-innodb-or-myisam-tables/#findComment-1111739 Share on other sites More sharing options...
brianlange Posted September 16, 2010 Author Share Posted September 16, 2010 The records are real estate listings that web visitors view. The table does not get updated with any additional information. Quote Link to comment https://forums.phpfreaks.com/topic/213591-innodb-or-myisam-tables/#findComment-1111777 Share on other sites More sharing options...
Mchl Posted September 16, 2010 Share Posted September 16, 2010 I would advise to use InnoDB mostly because it's a crash safe solution and in most situations performs equally well as MyISAM. The only reason to use MyISAM nowadays (IMHO) is it's full-text search feature (which is absent from InnoDB, but you can use external software to provide this functionality). Quote Link to comment https://forums.phpfreaks.com/topic/213591-innodb-or-myisam-tables/#findComment-1111792 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.