On Fri, 2006-03-31 at 07:21 -0500, Sean Davis wrote: > On 3/31/06 6:59 AM, "Tomas Zerolo" <[EMAIL PROTECTED]> wrote: > > > (b) Repeat the query (making sure there is a sort criterium) at each > > page request, starting at a variable offset and limiting the > > result set
> Also, you might have a look at this: > > http://perlmonks.org/?node_id=492067 > > It probably falls into category b from above, but the AJAX component makes > this look like a pretty slick system. I have never tried it, but I found it > intriguing. > The DBIx::Livegrid module works well. The Ajax component "pre-fetches" say 100 rows; so if your page "length" is 30 rows, you will only hit the database every 3.3 pages. I haven't tested this in a high-volume environment though. --tielman ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************
