acidglitter Posted November 25, 2008 Share Posted November 25, 2008 I'm just barely finding out more about other storage engines. For one of my sites, select queries are run pretty often, but update queries run probably 10 times more often, and insert queries are rare. What type of storage engine would be best for my site? I'm using myisam now, and that's the only type I've ever really used. It seems to have problems with tables locking up every now and then and the site loads kind of slow sometimes. Quote Link to comment Share on other sites More sharing options...
Mchl Posted November 25, 2008 Share Posted November 25, 2008 Personally I recommend InnoDB. I use transactions very often. It's crash safe (or safer than MyISAM anyway). And for most cases it's just as fast as MyISAM (it gets worse, when there are really many reads from database). Also remember, that you can choose storage engine on per table basis. 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.