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
>

Reply via email to