Re: *** SPAM *** Re: reasons for modperl declines?

On Thu, 8 Aug 2024 13:11:18 +0200
Guido Brugnara <[email protected]> wrote:

Hi Guido,

>=20
> Special feature of the project is the use of HTML::Mason also for SQL=20
> code generation templates for efficient paging of very large recordset=20
> (even millions of rows).
>=20

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 of=
fset (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 fa=
st; but I do have to fetch the whole recordset every time so I suspect fetc=
hing 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?


--=20
					Bien =E0 vous, Vincent Veyron=20

https://compta.libremen.com
Logiciel libre de comptabilit=E9 g=E9n=E9rale en partie double