On 22 Feb 2013, at 8:31, Eduardo Morras wrote:

The only thing i can think that explain it is compilation options, specifically SQLITE_TEMP_STORE=0. If you do pragma temp_store=2, does it work better?

Nope.

I did check all this stuff out, got ideas from people in the #sqlite IRC channel, and so on. I am pretty sure there is an actual problem, which may well be fixed in 3.7, but I am sort of suspecting that there may be remnants, and that :memory: performance might have significant room for improvement.

-s
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to