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:[EMAIL PROTECTED] > Sent: November 29, 2006 3:01 PM > To: [email protected] > 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
