just curious for a 4 million records lowIndex, highIndex - lowIndex + 1 1, 4million- 1+1 = 4million. the other is for 200 only.
Chris Howe sent the following on 12/31/2007 5:24 PM: > I've recently been playing with a data set that has about 4 million > records in the Person entity and am having some performance issues in > the Entity Data Maintenance portion of Webtools. > > The only search term is partyTypeId="PERSON" > > The bottleneck is the resultEli = delegator... It takes about 30 > seconds > > efo.setResultSetType(EntityFindOptions.TYPE_SCROLL_INSENSITIVE); > EntityListIterator resultEli = null; > resultEli = delegator.findListIteratorByCondition(entityName, > condition, null, null, null, efo); > resultPartialList = resultEli.getPartialList(lowIndex, highIndex - > lowIndex + 1); > > running the following query from the mysql command line take 0.80 > seconds > SELECT * FROM person WHERE party_type_id="PERSON" limit 0,200; > > Can anyone offer assistance as to why the discrepency? > > > >
