Mailing-List: contact embperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Date: Thu, 22 May 2003 22:22:09 +0000
Message-ID: <87n0he62r2.wl@cat.pasture.com.au>
From: Angus Lees <gus@inodes.org>
To: Robert <robert@robert.cz>
Cc: cprince@rideware.com,
	embperl@perl.apache.org
Subject: Re: RH 9.0 RPMs - Query Results Question
In-Reply-To: <3ECCA838.9090305@robert.cz>
References: <001e01c32009$aa1eb700$6401a8c0@rwl1>
	<3ECCA838.9090305@robert.cz>
Mail-Followup-To: embperl@perl.apache.org
User-Agent: Wanderlust/2.10.0 (Venus) XEmacs/21.4 (Portable Code)
   When George Bush projectile vomits antipasto on the Japanese.
MIME-Version: 1.0 (generated by SEMI 1.14.4 - "Hosorogi")
Content-Type: text/plain; charset=US-ASCII

At Thu, 22 May 2003 12:36:40 +0200, Robert  wrote:
> You'll have to do it manually. If the query is fast, use Limit/Offset or 
> equivalent otherwise Embperl::Session is your friend. And take a look at 
> DBIx::Recordset. BTW, it would be nice extension to Recordset - Gerald?

see the DBIx::Recordset->PrevNextForm function for a wrapper into the
Limit/Offset method.

also read Intrors.pod from DBIx::Recordset for a worked embperl
example.


grabbing all the results in one go, storing it in %udat somewhere and
then displaying only a certain range of the precached results should
be quite straightforward to implement yourself.

the cost of repeatedly retrieving such a large stored session might
well be more than the cost of redoing your search query though.

-- 
 - Gus

---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org