The result in a .csv format for Mikael, Sorry I'm very bad in html, I hope someone can re-post it in a nice-looking html table
Nota : - Postgresql is not tuned at all, and its figures move a lot between two measures, - I couldn't do a Pandas measure because "not enough memory". "sequence of operations \ time sec(at first try)","postgresql9.2.3","sqlite3.8.3.0 7200rpm_disk.db","sqlite3.8.3.0 :memory:","sqlite3.8.3.0 7200rpm_disk.db compiled -o2","sqlite3.8.3.0 :memory: compiled -o2" "loading 5 344 498 records * 18 columns from .csv",78,151,131,137,51 "select cand_nm, sum(contb_receipt_amt) as total from fec group by cand_nm ",54,22,20,11,10 "select cand_nm, sum(contb_receipt_amt) as total from fec group by cand_nm -- a second time",5.1,22,20,11,10 "select cand_nm, contbr_st, sum(contb_receipt_amt) as total from fec group by cand_nm, contbr_st",5.6,27,23,16,14 "CREATE INDEX xyzzy2 ON fec(cand_nm, contbr_st, contb_receipt_amt)",176,43,38,30,25 "select cand_nm, sum(contb_receipt_amt) as total from fec group by cand_nm,",4.9,3,3,2,2 "select cand_nm, contbr_st, sum(contb_receipt_amt) as total from fec group by cand_nm, contbr_st,",5.6,4,4,3,3 "total time (not relevant)",329,272,239,210,115 "relative speed-up (not relevant)",-21%,0%,12%,23%,58% _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users