-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 16/10/11 20:22, Sreekumar TP wrote: > Does the first execution of step cache the entire result set and tje > subsequent steps get the results from the cache?
No, the first execution does the minimum amount of work necessary in order to get you the first result row. Subsequent steps do only the work necessary to get the next row. However if your query needs the rows to be sorted then all of the result rows will have to be found first in order to do the sorting. (Some sorts can be satisfied from an index.) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6botAACgkQmOOfHg372QS+1gCeNPAie5rgEcUH+2gFJAT8iZVq n5UAoMl0HkipR2qN5Vr9dLg+jc+3dYhT =rHPf -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
