Teg wrote: >> > Yeah, it's not that fast at all. I moved away from SQLite for one part > of my application because COUNT was slow. If the data's not in the OS > cache, it's real slow. > > One possibility would be to maintain an approximate count in a > different table. That didn't work for me because my counts were time > dependent and depended on some RE filtering. >
Are you saying you found another database that maintains accurate counts of records that will be returned from a query that uses a regular expression to filter the data without actually executing the query? This sounds lie magic to me. How could it possibly know which regular expression you are going to use in a given count query? Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
