Just to be clear, from my point of view at least, the big difference is between: - Multiple threads performing concurrent queries (with or without the shared cache) vs - Multiple processes performing concurrent queries
In the latter case (for a number of queries chosen to lie within the expected number of hardware cores/hyperthreading on the test machine) the time taken to process all the queries is just a tiny fraction longer than the time it takes to process a single one. Whereas in the former case I find that the time to process all the queries is commensurate with having lost much of the concurrency - much more akin to the time taken if you had serialised the processing of all the queries. On 2010-03-12, at 12:57 AM, Marcus Grimm wrote: > I'm not able to reproduce the reported behavior that a single process > queries faster than a single thread. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
