> Keith found the answer: you don't have the indexes required to make your > FOREIGN KEYs run quickly.
Thanks, I will try that. > If you DELETE FROM the child tables first, do you get fast or slow times ? Yes, I already tried deleting from each table individually. It's slow everywhere. > Thee way you're doing it involves a lot of steps as SQlite works its way > through the parent table, deletes one row from that, and cascades through the > other tables, looking for and deleting related rows from those. Ok, I might have errors in my declarations, but SQLite seems to have problems as well, because MariaDB (without any explicit index defintion!) handles the same deletion within seconds... _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users