On 09.10.2012 12:46, Clemens Ladisch wrote:
Marcus Grimm wrote:
I can see that the application increases memory up to appx. 600 MB
while the database is populated - That is the cache_size=500000,
I assume.
cache_size=500000 corresponds to:
255 MB (page size 512 bytes)
488 MB (page size 1 KB)
977 MB (page size 2 KB)
1.9 GB (page size 4 KB)
What does "PRAGMA page_size;" say in your database?
I think it the default value (1 KB).
And are you running in a 32-bit or 64-bit process?
It is a 32 bit process on a 64 bit Win7 machine.
During the process of inserting the test data the
memory usage increases constantly to around 650 MB and
remains there - no problem with that. Sqlite just fills the cache
that I specified.
It is interesting though, that create index appears to require
memory above the specified page cache. No problem actually
but one need to be aware about it.
Anyway, everything works now and I can proceed.
Marcus
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
