ammon_lymphater wrote:
> - during import the memory growth up to 800 mb (the cache size)
> - during select count(*) it goes up to 1.5gb
> - when starting select ... group by the memory it goes up to 1.6 gb
> for successful imports, up to 2gb for out of memory condition
This looks as if all temporary data is stored in memory (of which you
don't have too much in a 32-bit process.)
What is the value of "PRAGMA temp_store;" and the default setting of
TEMP_STORE ("PRAGMA compile_options;")?
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
