Perfectly Ok for me.
Nissim wrote:
>
> 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]
--
Didier Dubois
mailto:[EMAIL PROTECTED] http://www.idbsoft.ch
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
