Posted by Aggelos on 12/21/06 11:15

> INNODB + mysqli = good database that supports transactions and understands
> constraints like FK.
>
> MyISAM + mysql = poor but fast database. (It is fast because it checks
> nothing, and the integrety of the data is the programmer's problem.)

Thanks Erwin

Although that's not what I wanted at that stage to hear, is good to
know about mysqli.
I knew about the MyISAM problems but some people think it is better to
have control thru PHP rahter than in DB. And that is sort of true.
Because if MySQL throws an error that it is restricted to delete that
record, how are you going to handle it ?
Although my logic says that you should do a relationship crosscheck in
both PHP and DB, so even if you forget to handle them thru PHP you can
have them handled by a Properly deisgned DB.

Regards,
Angelos.

[Back to original message]