From: Ed Carp
Date: March 12 1999 7:24pm
Subject: Re: sort of defragmentation?
List-Archive: http://lists.mysql.com/mysql/142
Message-Id: <005301be6cbe$292f3be0$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>Yes, but all DELETE/UPDATE without dependencies would also have to look
into the dependencies table, and that's an extra overhead.


Well, yes, but you'd gain integrity. :)  There's no way to do it without
having extra overhead.

>Also I have a running application, which uses dependencies between two
databases.
>They wouldn't be handeled this way. This would lead to do it myself on some
queries
>and let it do mysql on others. Not very transparent.


If the table were global and database_name fields were added, it'd work.
Also, you want to be able to turn it on and off.

>I think when stored procedures are out in mysql, you could do such things
if you need it.
>Till then be patient :)


I'm scratching my head- what do stored procedures have to do with integrity?
Triggers would help, because mysql could set up internal triggers to check
the integrity itself - is this what you meant?