are you using an entity OTTB? Some DB will not handle Cursors.
Foo Shyn Chung sent the following on 10/6/2011 12:48 AM: > Hi guys, > > Would like to ask what is the mechanism used in Ofbiz for multi page > listing? > > 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). > > Not sure whether anyone has encountered this before? > > Thank you > FooShyn >
