I'm using a database with 5 hierarchically strcutured tables using foreign keys. The largest table contains about 230'000 entries. My problem is that deleting in this database is extremely slow:
pragma foreign_keys=on; pragma journal_mode=wal; .timer on delete from dataset; --> Run Time: real 197993.218 user 53015.593750 sys 54056.546875 I experimentally imported the same data into a MariaDB database and tried the same operation there (without paying attention to creating any indexes, etc.). It takes only a few seconds there. Is there something I can check or do to improve deletion speed? Kind regards, Thomas _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
