CL> This looks as if all temporary data is stored in memory (of which you
CL> don't have too much in a 32-bit process.)
Yeah, this. Typically you only have 2 gigs of address space to work
with, in 32 bit windows. I've run out of RAM by having
"temp_store=memory" before. I also have 30-60 GB DB files that I
operate on that don't have any issues like this.
CL> This looks as if all temporary data is stored in memory (of which you
CL> don't have too much in a 32-bit process.)
CL> What is the value of "PRAGMA temp_store;" and the default setting of
CL> TEMP_STORE ("PRAGMA compile_options;")?
CL> Regards,
CL> Clemens
CL> _______________________________________________
CL> sqlite-users mailing list
CL> sqlite-users@sqlite.org
CL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards,
Teg mailto:t...@djii.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
