Bart Smissaert <bart.smissa...@gmail.com> wrote: > In fact when doing something as you suggest: > select * from MyTable where ID <= 14 order by ID desc > I can make it a lot more efficient by adding a limit as not many > records will be needed.
There's no difference between adding a LIMIT N clause to the query, and simply calling sqlite3_step N times and then resetting or finalizing. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users