Another point being, fully normalized data can be a bear to extract. I see penalities in my humble database reports, so I leave 3rd and 4th normalization for managers wish lists. ;)
On Fri, Dec 27, 2019, 6:37 PM Simon Slavin <slav...@bigfraud.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users