Re: on delete cascade slowing down delete

On Thursday 21 August 2008, Ivan Sergio Borgonovo <mail@webthatworks.it>
wrote:
> I've a large table with a pk and several smaller tables with fk
> referencing to it.
>
> deleting from the first table is very slow.
>
> Not all the related fk have indexes but they are VERY small (0 to
> 100 records) while the main table contain 600-800K records.
>
> the
> explain delete p;
> doesn't give any clue.
>
> Any hint to track down the problem?

1) Define slow.

2) Tell us what your disk subsystem consists of.

3) Are there any delete triggers on the tables?

--
Alan