Re: sort of defragmentation?

[Ed Carp]

>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?