>pragma foreign_keys=on; >pragma journal_mode=wal; >.timer on >delete from dataset; >--> Run Time: real 197993.218 user 53015.593750 sys 54056.546875
Wow. That is 14 hours each of System and User time and then and additional 24 hours of "waiting for something to happen" time. Do you have memory to run this in? Have you increased the sqlite cache size because that looks (to me) an awful lot like I/O thrashing ... -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
