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
sqlite-users mailing list

Reply via email to