On Mon, Sep 22, 2014 at 1:43 PM, big stone <stonebi...@gmail.com> wrote:
> Hi, > > This 3.8.7alpha release seems to bring about 5% win from 3.8.6 , on my > particular SQL test case. > > Question : "PRAGMA threads=2" didn't bring any speed-up on my "2 true" > cores machine. > > Did I miss a compilation option ? > The multi-thread sort should be on by default. Probably you are just not doing a big enough sort to make it worthwhile to start any new threads. The "threads=2" pragma sets an upper limit on the number of threads. There is no guarantee that SQLite will use that many. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users