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 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. Link to comment https://forums.phpfreaks.com/topic/96854-selecting-a-database/#findComment-495876 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.