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?
