Subject | Re: [firebird-support] Re: Foreign Keys vs Performance |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-12-14T02:36:16Z |
Adam wrote:
problem with lot of duplicates are gone forever. :-)
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>There are two sides pulling against each other. The purist wouldI am a purist, I will be a happier purist when FB 2.0 is out and the
>demand each FK explicitly defined, and there is good argument for
>this. If you do not define the FK, then you must write custom triggers
>to emulate a FK, and risk inconsistent data if you do it wrong. At
>least with FK's defined, you can not possibly store a child record
>without a parent record to reference.
>
>
problem with lot of duplicates are gone forever. :-)
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br