Re: Slow deletes (MariaDB)

Jerry Stuckle <[email protected]> Fri, 20 Aug 2021 14:00:46 -0400

Newsgroups	comp.databases.mysql
Organization	A noiseless patient Spider
Message-ID	<[email protected]>

On 8/20/2021 1:34 PM, DFS wrote:
> Deletes of this type are very slow:
> 
> delete from childtbl
> where id1 in
> (
>    select id1
>    from parenttbl
>    where id2 in
>    (
>     select id2
>     from othertbl
>     where condition
>    )
> )
> 
> 
> Like 1.5 minutes to delete a couple thousand rows.
> 
> How can I speed them up?
> 
> 

How big are your tables?  Do you have indexes on id1 and id2 in their 
appropriate tables?

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
[email protected]
==================