MESSAGE
| DATE | 2024-08-08 |
| FROM | Vincent Veyron
|
| SUBJECT | Re: [Hangout - NYLXS] *** SPAM *** Re: reasons for modperl declines?
|
On Thu, 8 Aug 2024 13:11:18 +0200
Guido Brugnara 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
_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://lists.mrbrklyn.com/mailman/listinfo/hangout
|
|
