On Tue, Jul 29, 2008 at 4:25 AM, <[EMAIL PROTECTED]> wrote: > On Tue, Jul 29, 2008 at 03:27:20AM -0500, Robert Citek wrote: >> real 3.25 > .. >> real 22.48 > > I'm seeing the second being twice as -fast- as the first one here, still.
I don't follow. 22/3 ~ 7. Or do you mean when you run the same script on your machine? > How many CPU cores are in your testing machine? Parallel execution > -might- explain the difference. Tried this on two different machine, both dual cores. Same sqlite3 version but with slightly different kernels (2.6.22 vs 2.6.24). Similar results: + sqlite3 sample.db 'select foo from bar ; ' + uniq + sort + uniq + wc -l 2000000 real 4.33 user 5.01 sys 0.66 + sqlite3 sample.db 'select count(distinct foo) from bar ; ' 2000000 real 29.67 user 29.12 sys 0.43 Regards, - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users