Have you added timing to see which part of this is taking a long time? The main candidates would probably be the findListIteratorByCondition call and the getPartialList call.
You could also change it to not do the scroll insensitive... MySQL might be doing something funny with that...
-David On Dec 31, 2007, at 6:24 PM, Chris Howe wrote:
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?
smime.p7s
Description: S/MIME cryptographic signature
