Hi Mikael, I'm not expert in rtree virtual table handling, but you may try and post the result here . Adding the test of the -o2 compiled SQLite3.8.3.exe (size 801Ko vs 501Ko for the standard Sqlite, 'size' optimized)
- feeding data : . in disk database : 151 seconds . in memory database : 131 seconds (25% = 1 cpu used out of 4) . in memory database -o2 compilation : 51 seconds (25% = 1 cpu used out of 4) - creating index CREATE INDEX xyzzy2 ON fec(cand_nm, contbr_st, contb_receipt_amt) : . in disk database : 43 seconds . in memory database : 38 seconds . in memory database -o2 compilation : 25 seconds - select cand_nm, sum(contb_receipt_amt) as total from fec group by cand_nm ; . in disk database : 22 seconds . in memory database : 19 seconds . in memory database -o2 compilation : 10 seconds . in disk database with index: 3 seconds . in memory database with index : 3 seconds . in memory database -o2 compilation with index : 2 seconds - select cand_nm, sum(contb_receipt_amt) as total from fec group by cand_nm ; . in disk database : 27 seconds . in memory database : 24 seconds . in memory database -o2 compilation : 14 seconds . in disk database with index: 4 seconds . in memory database with index : 4 seconds . in memory database -o2 compilation with index : 3 seconds The effect of -o2 is quite significant on these tests. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users