On Sat, 21 Mar 2009 16:37:15 -0500, P Kishor <punk.k...@gmail.com> wrote:
> [04:24 PM] ~/Data/carbonmodel$perl carbonmodel.pl > Creating in memory tables... done. > Transferring data to memory... done. Took: 90 wallclock secs (75.88 > usr + 8.44 sys = 84.32 CPU) > Creating indexes... done. Took: 38 wallclock secs (23.82 usr + 13.36 > sys = 37.18 CPU) > Prepare load testing > ...timethis 1000: 33 wallclock secs (30.74 usr + 1.02 sys = 31.76 > CPU) @ 31.49/s (n=1000) Loading and indexing is pretty fast. >So, I increased the cache_size to 1048576 but got the same results... >30 odd SELECTs per second. With a cache of 1M pages with a page_size of 32 kByte, your cache would amount to 32 GByte, that's not realistic on a 32bit-mode OS. Maybe you should try PRAGMA [default-]cache_size=50000 ? That's 1.5 GByte, and would leave some headroom for OS diskbuffers. > I will try out with PostGres and report back on what I get. I'm curious. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
