Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 1393 invoked from network); 29 Nov 2006 20:01:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Nov 2006 20:01:10 -0000 Received: (qmail 7553 invoked by uid 500); 29 Nov 2006 20:01:19 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 7366 invoked by uid 500); 29 Nov 2006 20:01:19 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 7357 invoked by uid 99); 29 Nov 2006 20:01:18 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Nov 2006 12:01:18 -0800 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,MSGID_FROM_MTA_HEADER,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of danz8086@hotmail.com designates 65.54.246.91 as permitted sender) Received: from [65.54.246.91] (HELO bay0-omc1-s19.bay0.hotmail.com) (65.54.246.91) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Nov 2006 12:01:04 -0800 Received: from hotmail.com ([65.54.174.83]) by bay0-omc1-s19.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 29 Nov 2006 12:00:44 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 29 Nov 2006 12:00:40 -0800 Message-ID: Received: from 199.243.96.18 by BAY103-DAV11.phx.gbl with DAV; Wed, 29 Nov 2006 20:00:37 +0000 X-Originating-IP: [199.243.96.18] X-Originating-Email: [danz8086@hotmail.com] X-Sender: danz8086@hotmail.com From: "dan" To: Subject: RowIterator loop is slow? Date: Wed, 29 Nov 2006 15:00:36 -0500 Message-ID: <000301c713f1$09236870$6a05140a@pointalliance.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AccT6z8WO3wwg0yBQjesTxoGT4ASjgABMWQw In-Reply-To: <1164827922.31872.8.camel@localhost> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-OriginalArrivalTime: 29 Nov 2006 20:00:40.0748 (UTC) FILETIME=[0BB006C0:01C713F1] X-Virus-Checked: Checked by ClamAV on apache.org Hi, I was using RowIterator to loop through about 2000 entries in query result and it took about 3+ seconds. I stripped the code to the bare loop structure like below: logger.debug("start loop"); while (rows.hasNext()){ Row row = rows.nextRow(); Value[] values = row.getValues(); } logger.debug("end loop"); The time for going through the entire RowSet is still 3+ second. Tried with NodeIterator, the result did not change much. Could anyone advise if this is the normal performance? I'm running this code on a Windows 2003 server. Thanks, Dan