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?