On 11 May 2018, at 9:50pm, Deon Brewis <d...@mylio.com> wrote:
> e.g. If you do:
> SELECT c1 from t1 ORDER BY c2 LIMIT 5;
> vs. just running the query without the "LIMIT" clause and taking the top 5
> rows programmatically?
The LIMIT clause just tells sqlite3_step() to return SQLITE_DONE after the
fifth result. The only difference is whether you want to count to 5 in your
own code or have SQLite do it for you.
In practise, you may have a specific reason for wanting the limit to appear in
the SQL command, or not wanting it there. It may be part of your business
practise or it may be a detail of how your software works. Do whatever the
reader would find easiest to understand.
Remember in both cases to do sqlite3_finalize() or sqlite3_reset() once you
have finished fetching results.
sqlite-users mailing list