> 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

Indeed I am ...

You do have relationships, but you're not letting the DBMS guarantee
data-correctness...

In my opinion, a very bad thing...

Constraints is one of the main strengths of a DBMS...

Really, you should use them and find another way to get around poor
performance if this is an issue.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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

> Alan
> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: Wednesday, 28 August 2002 20:01
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Re: Helen: Low Selectivity Problem
>
>
> Alan,
>
>
> > 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
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>