List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:July 23 1999 2:41pm
Subject:Re: Referential Integrity Question
View as plain text  
>>>>> "s" == sinisa  <sinisa@stripped> writes:

s> What is a use of saving a foreign key if it is not used ???

s> I can see one and only one reason. To make my optimized queries in
s> sqlclient (www.tcx.se/download_clients.html) even more optimized.

s> But the issue was referential integrity and it involves far more than
s> just saving foreing keys, which is in TODO list, by the way. Do you
s> know what a slowdown it would be for UPDATE/DELETE ... WHERE ...., if
s> full referential integrity would be implemented ??

I don't think you're getting my point:  You say having the ability to
do foreign keys would slow down the server.  I say no.  I say that
having the ability to use foreign keys would not slow it down, but
actually *using* them would slow it down.  This is ok, since there is
no penalty when I don't use them.

Please explain to me why making this feature available would slow down
MySQL when it is not in use.

It sounds to me like saying "indexes are not supported since they slow 
down inserts".

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
Referential Integrity QuestionPing Lau23 Jul
  • Re: Referential Integrity QuestionPatrick Greenwell23 Jul
  • Referential Integrity Questionsinisa23 Jul
    • Re: Referential Integrity QuestionVivek Khera23 Jul
      • Re: Referential Integrity Questionsinisa23 Jul
        • Re: Referential Integrity QuestionVivek Khera23 Jul
          • Re: Referential Integrity Questionsinisa23 Jul
            • Re: Referential Integrity QuestionVivek Khera23 Jul
              • Re: Referential Integrity Questionsinisa23 Jul
                • Re: Referential Integrity QuestionMartin Ramsch23 Jul
                  • Re: Referential Integrity QuestionMichael Widenius2 Aug