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 <[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? >>> >>> >>> >>> >> > > > >
