On Thu, Nov 27, 2008 at 11:19 AM, Bastien Koert <[EMAIL PROTECTED]> wrote:
> 2. It is possible to use the application to handle the keys instead of the
> database, it involves more work around key checking / validation before
> creating or updating records, but it can be done if the INNODB table type is
> not accessible to you for some reason.

Yes, but generally foreign key constraints are preferable.  The
database server is compiled in native code, so it'll be much faster at
handling this issue; and it may avoid the necessity of your script
submitting multiple queries to resolve the foreign key issues.  A
bigger issue though is that the implementation of foreign key
constraints on the server will have been exhaustively tested.
Reinventing the wheel in your own PHP code may introduce bugs that
cause loss or damage to your data.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to