Thank Bilgin, Sorry, forgot to mention. The version i'm trying out is ofbiz 10.4
I'm looking at *org.ofbiz.entity.util.EntityListIterator*in ofbiz source, this is the class used throughout the whole ofbiz entity engine to pull results for listing page? Thanx FooShyn On Thu, Oct 6, 2011 at 4:54 PM, Bilgin Ibryam <[email protected]> wrote: > On Thu, Oct 6, 2011 at 8:48 AM, Foo Shyn Chung <[email protected]> wrote: > > Hi guys, > > Hi FooShyn, > > > > > Would like to ask what is the mechanism used in Ofbiz for multi page > > listing? > > have a look at java.sql.ResultSet.EntityListIterator class > > > > > Currently we have a live site whereby the listing would resulted in a few > > thousands rows being returned and displayed on multiple page on the > screen. > > We found that once the data amount hit a certain amount, the performance > of > > that page will become very slow. > > > > For listing, is Ofbiz will load up all the results in the memory, then > only > > segregate them into multiple page? or they only will load the data when > the > > user is viewing the page (i.e. when the user click next page, then the > data > > for the next page is loaded). > > the latter > > > HTH > Bilgin > > > > > > Not sure whether anyone has encountered this before? > > > > Thank you > > FooShyn > > >
