InnoDB is very fast. In theory, I guess MyISAM is considered faster (that may not even be true these days). We're talking about fine hairs here and I haven't heard anybody complain about InnoDB-specific speed problems. Anyway, if you're using Windows, you're must not be too concerned about speed ; - )
> -----Original Message----- > From: Rodolphe Toots [mailto:[EMAIL PROTECTED] > Sent: Monday, June 16, 2003 5:00 AM > To: [EMAIL PROTECTED] > Subject: fastest DB engine > > > hi all! > > i am currently working on a community projekt > the DB is a mySQL DB but i am not sure which engine to use > i know that innoDB supports foreign keys which i really want > i order to > keep the data consistent since there will be a lots of insert, delete > and update activity with forums and guestbooks and new users and so on > and i know i can have different table types in the same DB > > but from what i've learned myISAM is the fastest > is this true > > second, i have followed some discussions here about foreign keys > but i still have nog managed to create foreign keys > > i have a table users and another userTypes where > > tblUsers have columns > userID, usertypeID, username, password... > > and tblUserType > userTypeID, userType > > so i want userTypeID in tblUsers to be a foregn key referencing the > userTypeID col in userTypes > both tables are myISAM > userID is indexed and primary key in tblUsers > userTypeID is indexed and primary key in tblUserType > userTypeID in both tables are int(10) > > what is wrong? > my OS is win XP pro and i have mySQL 4.1 (not really sure > exact version > since i cannot reach the DB from where i am right now) > > thanks in advance > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
