-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/10/11 15:52, Simon Slavin wrote: > But I was sure I had read that in SQLite the full result set was > retrieved even if LIMIT was used.
For the outer query all LIMIT does is cause sqlite3_step to return done after limit number of calls. ie you could omit LIMIT and just call finalize after you've had as many results as you want and it wouldn't make any difference. Similarly the first offset number of times when a row would be returned are skipped. Although various people keep mentioning it I haven't seen you acknowledge using EXPLAIN QUERY PLAN. It would be nice to hear if it turns out to be helpful especially as it doesn't require mucking with the query itself. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6PpwoACgkQmOOfHg372QS/7gCdEtt7iuh1fOkZDP5lw/WMKEm4 OPEAoNOH6+A88h05+YC9XAFYJeVO0X1d =AJuc -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users