Neomech Posted March 19, 2008 Share Posted March 19, 2008 Hi, I'm totally new at PHP and MySQL, but I've got a fair bit of experience with MS SQL2005. My question relates to the different database types, particularly MyISAM and InnoDB. My very general understanding is that MyISAM is not "strict" (no foreign keys) but has a very fast "count" ability, whereas InnoDB is the opposite (more similar to PostgreSQL). Is that correct or am I off my rocker? I am used to using foreign keys, and appreciate them from a database design perspective, however I'm also looking for a database that will be pretty quick at delivering a count back to me. Any recommendations? If you want to push Postgre as an alternative, I'm not totally sold on MySQL, although I tend to think given how widely it's used I'll find an easier time getting help as I learn a new system. Thanks in advance for any replies Quote Link to comment https://forums.phpfreaks.com/topic/96854-selecting-a-database/ Share on other sites More sharing options...
fenway Posted March 19, 2008 Share Posted March 19, 2008 These engines are completely and utterly different -- don't get hung up on that "count(*)" issue, since it's mostly irrelevant. I think there are some relevant stickies. Quote Link to comment https://forums.phpfreaks.com/topic/96854-selecting-a-database/#findComment-495876 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.