On Wed, Apr 19, 2017 at 8:02 AM, Antony Courtney <ant...@antonycourtney.com> wrote:
> Tad uses LIMIT and OFFSET to only pull as many rows as needed to display > the current viewport, even in the presence of pivoting, so it's possible to > use Tad on large tables. > I'm no expert at all in this domain, but I believe it was discussed several times on this list that using LIMIT and OFFSET for a "scrolling cursor" is not the most efficient way to achieve that goal. Hopefully experts like DRH, James, and co. will provide more information and pointers (which I can't find right now). FWIW. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users