List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:December 27 2003 5:35pm
Subject:Re: foreign keys plz?
View as plain text  
* Alaios
> with myIsam? Does not check about integrity?

That is correct, the myisam table handler does not support foreign key
constraints. It does of course support foreign keys, but not foreign key
constraints, consequently the foreign key itegrity is not checked for myisam
tables.

> Mysql 3.2?

(I suppose you meant 3.23)

> What u will use for your application Innodb or MyISAM?

Both? It would depend on your needs. Foreign key constraints is neat, and in
some projects it might be a requirement, but the myisam table handler is
"lighter" because it does not do these checks, and it is also not
transactional, thus it is faster than InnoDB in many cases. myisam also
requires less disk space.

Read more about the different table handlers in the manual, and note that
you can combine different table types in the same database and in the same
statement:

<URL: http://www.mysql.com/doc/en/Table_types.html >

--
Roger

Thread
foreign keys plz?Alaios27 Dec
  • Re: foreign keys plz?Martijn Tonies27 Dec
    • Re: foreign keys plz?Alaios27 Dec
      • Re: foreign keys plz?Roger Baklund27 Dec