What about this:
SELECT CASE count(*) WHEN 5000 THEN 'More than 5000' ELSE 'Less than 5000' END FROM (SELECT ID FROM table ORDER BY whatever LIMIT 5000 OFFSET 25000) Fabian schrieb: > 2011/10/16 Frank Missel <i...@missel.sg> > >> What do you want to attain with the count? >> >> > I want to allow users to paginate through a result set. The pages are > retreived through LIMIT/OFFSET, but to calculate the total number of pages, > I have execute a separate COUNT() query (without LIMIT) once. > > Because I'm basicly executing the same query twice just to get a total > count, I'm trying to optimize this. Restricting the maximum number of pages > to 10 should improve performance, if there was some way to put make COUNT() > respect the LIMIT specified. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users