----- 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]

Reply via email to