Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 68782 invoked from network); 14 Dec 2007 20:56:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Dec 2007 20:56:10 -0000 Received: (qmail 45921 invoked by uid 500); 14 Dec 2007 20:55:59 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 45890 invoked by uid 500); 14 Dec 2007 20:55:59 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 45881 invoked by uid 99); 14 Dec 2007 20:55:59 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Dec 2007 12:55:59 -0800 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Dec 2007 20:55:37 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1J3HZN-0004Mw-2n for derby-dev@db.apache.org; Fri, 14 Dec 2007 12:55:41 -0800 Message-ID: <14339792.post@talk.nabble.com> Date: Fri, 14 Dec 2007 12:55:41 -0800 (PST) From: yonestar To: derby-dev@db.apache.org Subject: Re: database chunking In-Reply-To: <14339770.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: yoni@higtek.com References: <14339770.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org Upon further investigation, I'm less sure about how setFirstResult() and setMaxResults() are actually working. does anyone know? using those methods, getting successive chunks and starting from the first row, i saw times of 20 secs, 50 s, 50 s, 50 s. leads me to think there is a constant time penalty for seeking to not the first row. -- View this message in context: http://www.nabble.com/database-chunking-tp14339770p14339792.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.