Re: Slow deletes (MariaDB)

Axel Schwenke <[email protected]> Fri, 20 Aug 2021 23:20:00 +0200

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

On 20.08.2021 19:34, DFS wrote:

> delete from childtbl
> where id1 in
> (
>   select id1
>   from parenttbl
>   where id2 in
>   (
>    select id2
>    from othertbl
>    where condition
>   )
> )

> How can I speed them up?

Show the EXPLAIN for the query. Then we can talk.

https://mariadb.com/kb/en/explain/