Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (herse.apache.org: domain of danz8086@hotmail.com
 designates 65.54.246.219 as permitted sender)
Message-ID: <BAY103-DAV88427E620D6F9166245A3D8E40@phx.gbl>
From: "dan" <danz8086@hotmail.com>
To: <users@jackrabbit.apache.org>
Subject: RE: RowIterator loop is slow?
Date: Wed, 29 Nov 2006 18:09:44 -0500
Message-ID: <000001c7140b$74fd6db0$6a05140a@pointalliance.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AccT6z8WO3wwg0yBQjesTxoGT4ASjgABMWQwAAavDyA=
In-Reply-To: <BAY103-DAV1193E062DA59AACFEB05BFD8E40@phx.gbl>

I've seen some discussion on slow performace on Window box. But those are
about using LocalFileSystem on Windows. In my case, the repository uses
SimpleDBPersistenceManager and DBFileSystem (DB2). 
I thought about maybe Lucene index on Windows file system is also slow to
search with, but since I've already got the RowIterator/NodeIterator, I
guess looping through the iterators has nothing to do with Lucene index.
Is that correct? 
Thanks
Dan


> -----Original Message-----
> From: dan [mailto:danz8086@hotmail.com]
> Sent: November 29, 2006 3:01 PM
> To: users@jackrabbit.apache.org
> Subject: RowIterator loop is slow?
> 
> 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