On 16 Oct 2011, at 2:50pm, Bart Smissaert wrote: > He is trying to make it more efficient, so stop counting if count > X. > So setting the count after having counted the whole lot won't help.
Then he can't use count() because SQLite's implementation of it is not efficient for that. Perhaps he could read the rows LIMIT 100 into a buffer (after all, he's going to need them eventually for when he displays them), then count how many rows he got. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
