ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: findListIteratorByCondition performance
Date Tue, 01 Jan 2008 04:28:59 GMT
I  change the qty in the URL to get higher number per page.
assumed you did the same.
:)

Chris Howe sent the following on 12/31/2007 8:14 PM:
> The webtools entity maint paginates 50 records @ a time
> 
> 
> --- BJ Freeman <bjfree@free-man.net> 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?
>>>
>>>
>>>
>>>
>>
> 
> 
> 
> 


Mime
View raw message