On Thursday, 31 October, 2019 16:54, Thomas Kurz <sqlite.2...@t-net.ruhr>:
>I did it again, same file: >SQLite version 3.30.1 2019-10-10 20:19:45 >Enter ".help" for usage hints. >sqlite> pragma foreign_keys=on; >sqlite> .timer on >sqlite> delete from dataset; >Run Time: real 5249.891 user 2412.812500 sys 2606.531250 Well, this indicates only 5% idle time, so it is much better. However, the process is spending a *HUGE* amount of time in the OS (sys), about half the elapsed time. This indicates that I/O thrashing is still occurring. In the CLI the command ".stats on" will output a bunch of execution statistics after executing a command. Included in those are the Page cache hits/misses/writes/spills. The hit rate (hits/(hits+misses)) is probably very low and the miss rate (misses/(hits+misses)) very high indicating I/O thrashing to the underlying OS (which will be reflected by increased sys time). -- 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
