On Thursday 21 August 2008, Ivan Sergio Borgonovo <mail(at)webthatworks(dot)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