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