InnoDB is using a totally different concept than MyISAM. Where in MyISAM all the data is in one file, InnoDB uses the principle of Tablespaces (like ORACLE). This puts the whole tables (and metadata) into one HUGE file (in theory. In practice this file can be split and extends can be defined of how it grows).
In general, MyISAM is faster. So if you are developing an application which is logging low level traffic information for telephony calls, use MyISAM. If you develop a "normal" application, like a webshop, you won't notice the difference. Executive Summary: If you need foreign constraints, use InnoDB. Cheers /rudy -----Original Message----- From: Andrew Kuebler [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 4:54 To: [EMAIL PROTECTED] Subject: Foreign Keys When I type: Show keys from [tablename]; I do not see foreign keys listed there and I cannot seem to find any command that will list foreign keys. Can anyone help? Also, I notice Innodb tables only store one file unlike MyISAM which stores 3. Are Innodb tables any slower than MyISAM since they store all data in a single file? I am looking to use Innodb for an application simply because of the referential integrity. Thanks in advance... Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]