perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tielman de Villiers <tvilli...@lastminute.com>
Subject Re: Database transaction across multiple web requests
Date Fri, 31 Mar 2006 12:30:21 GMT
On Fri, 2006-03-31 at 07:21 -0500, Sean Davis wrote:

> On 3/31/06 6:59 AM, "Tomas Zerolo" <tomas@tuxteam.de> 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
**********************************************************************


Mime
View raw message