ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Howe <cjhowe76...@yahoo.com>
Subject findListIteratorByCondition performance
Date Tue, 01 Jan 2008 01:24:03 GMT
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?


Mime
View raw message