Even though I already wrote the other stuff (never checked it in), I
think that this is a better idea. I'm going to change what I have to
work like this...anyone disagree?
Leon Messerschmidt wrote:
>
> Hi,
>
> Village has functionality of this sort already build into it (and I think BasePeer
> also supports stuff like this). It selects a certain number of rows from a
> specific offset. Can't we just add this capability to Criteria like this
>
> setOffset (int n)
> setNumRows (int n)
>
> Now we can just let it fall through and let Village handle the rest. I suspect
> Village cycles through the resultset <NumRows> times. Because the actual data is
> only transported once you ask for it this could give you the desired effect, it
> think?
>
> Might be a little slower that using a native LIMIT statement, but we can use it
> over *any* database that is currently supported.
>
> Any thoughts?
>
> ~ Leon
>
> ----- Original Message -----
> From: John McNally <[EMAIL PROTECTED]>
> To: Turbine <[EMAIL PROTECTED]>
> Sent: Friday, August 04, 2000 2:13 AM
> Subject: Re: PROPOSAL: Limiting resultsets with Criteria and BasePeer
>
> >
> > ----- Original Message -----
> > From: Paul O'Leary <[EMAIL PROTECTED]>
> > To: Turbine <[EMAIL PROTECTED]>
> > Sent: Thursday, August 03, 2000 11:21 AM
> > Subject: RE: PROPOSAL: Limiting resultsets with Criteria and BasePeer
> >
> >
> > > nissim,
> > >
> > > java.sql.Statement.setMaxRows( int ) is supposed to already give you this
> > > functionality, I believe.
> > > http://java.sun.com/products//jdk/1.2/docs/api/java/sql/Statement.html
> > >
> > > *although* it's completely up to the implementor of the JDBC driver
> > whether
> > > and how it's supported.
> > >
> >
> > And I have been told, though I didn't look myself, that some implementations
> > retrieve the entire resultset and then throw away most of them. So it is
> > not a safe way to limit memory consumption.
> >
> >
> >
> > ------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> > Problems?: [EMAIL PROTECTED]
> >
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
