Subject RE: [ib-support] Re: Helen: Low Selectivity Problem
Author Alan McDonald
What I mean is - I do not install the contraints. I, of course, use the
foreign keys since it would be impossible to work a Relational DBMS without
them, but I manage the foreign keys without applying the contraints.
You may still be frowning
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Wednesday, 28 August 2002 20:01
Subject: Re: [ib-support] Re: Helen: Low Selectivity Problem


> I might jump in here...
> I do not use foreign keys at all in my databases!
> ooooh I hear frowns and tisk tisks here....

You should have seen my face now - lots of frowns :)

It's logically incorrect NOT to use foreign keys (or other measures of
integrity) - this is what your DBMS is designed to do.

So if it gives poor performance when you are doing this, it's because of
implementation errors (or at least, not the best implementation possible).

Hence, I would rather have someone taking a stand here and sponsor
(money!!) the Firebird project to think of ways to do a better
implementation for FK-related issues with poor selectivity. This way,
one could still use FKs AND have decent performance.

Triggers for integrity ... ouch.

Just my 2 c...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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