Re: [sqlite] Is there ever a perf advantage to LIMIT outside of a subquery?

On 5/11/18, Deon Brewis 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? Yes, if there is an ORDER BY that cannot be satisfied by an index and the total

Re: [sqlite] Is there ever a perf advantage to LIMIT outside of a subquery?

On 11 May 2018, at 9:50pm, Deon Brewis 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