Subject | Re: Poor selectivity in foreign keys |
---|---|
Author | johnmancuk |
Post date | 2004-10-16T23:06:09Z |
You could still have potential problems, if you're using multiple
simultanious transactions.
TABLE STABILITY transaction isolation will ensure only one trans is
using the table at once. Either use that, or use indexes, to be
ultra-safe.
John
--- In firebird-support@yahoogroups.com, "Salvatore Besso"
<s.besso@m...> wrote:
simultanious transactions.
TABLE STABILITY transaction isolation will ensure only one trans is
using the table at once. Either use that, or use indexes, to be
ultra-safe.
John
--- In firebird-support@yahoogroups.com, "Salvatore Besso"
<s.besso@m...> wrote:
> hello all,the SP's for
>
> after having read all your replies, I still wonder if I can keep
> cascaded deletes. Maybe I forgot to say that this application isusing FB
> embedded and is single user, no network.FK indexes even
>
> Maybe if I would develop another networked application I'll keep
> if they slow down the application. What do you think about?
>
> Regards
> Salvatore