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