Am 14.02.2010 18:53, schrieb Max Vlasov: >> 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. > > For such problems i would suggest a different solution practiced by many companies :
Simply buying a Battery buffered RAM Drive. The Price (as an Example for the ASUS Drive) is about 250 $. For a governmental Solution 250 $ + RAM Costs won't really matter. The speed improvement (RAM Access is at least 10000 times faster than HD access) will make the costs ignorable. On the software side by simply inserting new Indexes a few thousand at a time in a completely new BTREE (memory) and Merging existing Pages with this new ones would make special sorting or other techniques unnecessary. Its the simplest and fastes solution. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
