Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (herse.apache.org: domain of david.vancouvering@gmail.com
 designates 64.233.162.235 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=twgOJsAr7B76gE3rknLtylHf07oLk+Trz5a/9DtRE0PC6e+d1805etxrqN5glYNPWa+9oVMEim4rssphZW9qTrdjPpHeiho/0yKsEEzVUy6tXffqV5/N0AMFZ6bWpyzl68ah51yFtatIYj3doLf50NaWYccGMv4xCZ6Ty4MrJM0=
Message-ID: <56a83cd00705111529p22af61e9l4a7dcff9f55fa5bb@mail.gmail.com>
Date: Fri, 11 May 2007 15:29:41 -0700
From: "David Van Couvering" <david.vancouvering@gmail.com>
To: derby-user@db.apache.org
Subject: maxrows - what does it really mean?
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

The behavior I want is to say get 10 rows at a time, with the least
amount of processing and network overhead wasted on rows that I am not
interested in yet.  What's the strategy for this?

the setMaxRows() method for Statement says:

"Sets the limit for the maximum number of rows that any ResultSet
object can contain to the given number. If the limit is exceeded, the
excess rows are silently dropped."

What I am wondering is, is there any way to tell the *server* to send
only a certain number of rows, rather than the server processing all
these rows and the client just dropping them.

Also, how is maxrows related to the fetch size of a ResultSet?

Thanks,

David