On 27 Dec 2019, at 9:57pm, Keith Medcalf <kmedc...@dessus.com> wrote:
> Setting "SINGLETHREAD" does indeed disable the multithreaded sorters. When > in one of the multithreaded modes, that query utilizes an average of 60% CPU, > compared to 12% when running singlethreaded. So if I understand this right, SQLite in multithread mode can itself use multiple threads at once, which means it can use many cores at once, which means it might be faster, most likely for complicated queries which involve lots of different things to be done. I'm slightly stunned. That had never occurred to me. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users