> This is appx. 500MB cache, why not trying with 2,000,000 cache size ? :-) > > Hmm, managed to increase it to only 1,000,000 (x1024) size, larger values bring to "Out of memory" finally, and this values (1G) allows up to 6,000,000 fast records for 100 bytes field per record index. Still good, such extreme cache method can work in many cases I think.
Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users