Jason Freshwater wrote: > 2. Read every record into my application and use a hashtable to > do my own select distinct. This is pretty good, about 0.6s to > achieve the distinct list (I can count each distinct value > along the way which is a useful side effect).
Would you mind my asking what language and what OS you are using? My best performance tests have given ~10,000 rows per second on Windows based machines, your results indicate two orders of magnitude better. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users