Subject Re: [firebird-support] Re: foreign keys ans slow insert
Author Tim Ledgerwood
At 02:16 PM 30/09/2004, you wrote:

>At 09:06 AM 30/09/2004 -0300, you wrote:
> >Well, i use lookups inside the application (Delphi) so can put the
> >checks inside the middle tier in ASTA, and remove that foreign keys.
> >Can you tell me if the next version of firebird will change that or will
> >remain in the same way?
>No, I can't tell you that. I only know that Arno is working on a solution
>to the problem of long duplicate chains in those low-selectivity indexes.


I have found it faster to use as few indices as possible. It speeds up
query and SP execution time incredibly. Is this anything to do with this

The reason I ask is because, coming from a dBase/Paradox background, I
thought (in the beginning) that I needed indices for just about everything.
With Firebird, I've learned not to put in indices.

I thought this may have something to do with this problem.



[Non-text portions of this message have been removed]