The webtools entity maint paginates 50 records @ a time
--- BJ Freeman <[EMAIL PROTECTED]> wrote: > 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? > > > > > > > > > >
