Re: [OFBiz] Users - Entity Engine Performance

Posted by David E. Jones on Nov 11, 2005; 4:58pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-OFBIZ-300-and-stand-alone-Tomcat559-It-almost-works-tp136430p136433.html


EntityListIterator.getPartialList() or calling EntityListIterator.next
() over and over does actually do this.

You didn't mention how you came to the conclusion that it is not  
doing this, so I can only guess at what the problem is. However,  
usually the problem is that the JDBC driver you are using does not  
support or is not configured to use database cursors.

So... which JDBC driver and database are you using? Also, what is the  
evidence that it is not paging over the results?

-David


On Nov 11, 2005, at 9:36 AM, Andrew Sykes wrote:

> Hi folks,
>
> Maybe this is a stupid question based on far to many consecutive hours
> of OFBizing, so bear with me...
>
> I'm working on a table with zillions of records, I want to work  
> through
> the whole set, but they don't all fit in memory at once.
>
> I thought the EntityListIterator.getPartialList() did this, but it
> appears that this actually pulls back all records first.
>
> Someone point me in the right direction please.
>
> Thanks
> --
> Andrew Sykes <[hidden email]>
> Sykes Development Ltd
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users