On Tue, Jun 26, 2012 at 4:46 AM, Bo Peng <ben....@gmail.com> wrote:

> >> In any case, you set the cache size in pages by executing "PRAGMA
> cache_size=<pages>" after opening the database connection.
>
> I am using "PRAGMA cache_size=-3000000" to set the cache to 3G, but
> the process is still slow-going using 23M of RAM, despite the fact
>

The problem might not be with sqlite, but with your system's allocator or
any number of other factors. Running it through a profiler is the only way
to know for sure. i use "callgrind":

valgrind --tool=callgrind --callgrind-out-file='callgrind.out' ./myapp

and then feed callgrind.out to kcachegrind or similar to get enough
detailed statistics to keep you busy for days.

-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to