Slow deletes (MariaDB)

DFS <[email protected]> Fri, 20 Aug 2021 13:34:10 -0400
Newsgroups comp.databases.mysql
Organization blocknews - www.blocknews.net
Message-ID <[email protected]>
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?