-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 30/06/13 20:17, Igor Korot wrote: > Well I'm not familiar with SQLite internals, but one thing for sure: > why go thru the process if you can avoid it?
You are trying to do premature optimization. Note the "Lite" in the SQLite. It is already designed and implemented to do the least amount of work - you haven't found a way to do less because SQLite is already doing the least! It only calculates the next (or first) result row when you ask for it, and not before. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlHRALsACgkQmOOfHg372QSjJgCgv0zNhFZRdOaR4gzaq4b6Qw9B 6HQAoMZcfyORD9++LT0iTJCT0Crs+pSn =xURz -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users