On Thu, 8 Aug 2024 13:11:18 +0200
Guido Brugnara <g...@leader.it> wrote:
Hi Guido,
>
> Special feature of the project is the use of HTML::Mason also for SQL
> code generation templates for efficient paging of very large recordset
> (even millions of rows).
>
Excuse me for hijacking this thread, but I'm curious how this works?
I have this problem in my accounting application, which I solved by adding
OFFSET $offset LIMIT 1000
to the query, plus links in the web page that point to the next/previous offset
(LIMIT is set at 1000 for browsers, which slow down after that).
It works fine for a few thousand rows, it serves the required slice very fast;
but I do have to fetch the whole recordset every time so I suspect fetching a
million rows to only return 1000 won't be efficient.
So, how do you a page an ordered recordset of a million rows? do you use a
cursor?
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale en partie double
