funnily enough i had a broken mysql / mariadb install that drop would not work at all - pinned a core to 100% - but delete would be instant in 1M rows lmao