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
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
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?
Obviously in the case of a subquery this makes a difference:
select count(*) from (select * from t1 limit 5);
But would it ever in a
3 matches
Mail list logo