Big paging listbox takes too long to render

answered 2013-02-19 07:01:40 +0800

dennis
3679 ● 1 ● 6
http://www.javaworld.com....

updated 2013-02-19 07:16:27 +0800

you should use ROD(ZK EE's feature) or it will new 'skeleton' listitems to listbox (in your case, they are 850000), read the document here

Or, you could build pagination manually for the best performance(control all the detail), here is my example by MVVM + JPA

zul

<window apply="org.zkoss.bind.BindComposer" title="Manual Paging"
    viewModel="@id('vm') @init('org.zkoss.jpa.examples.live.ManualPagingCatViewModel')"
    border="normal" hflex="1" vflex="1" contentStyle="overflow:auto">
    <hbox>
        <vbox width="400px">
            <paging 
                onPaging="@command('paging')"
                totalSize="@bind(vm.totalSize)" pageSize="@bind(vm.pageSize)" activePage="@bind(vm.activePage)"/>
            <listbox model="@bind(vm.availableCategories)"
                selectedItem="@bind(vm.selectedCategory)" rows="@bind(vm.pageSize)">
                <template name="model">
                    <listitem>
                        <listcell label="@load(each.name)" />
                    </listitem>
                </template>
            </listbox>
            <paging 
                onPaging="@command('paging')"
                totalSize="@bind(vm.totalSize)" pageSize="@bind(vm.pageSize)" activePage="@bind(vm.activePage)"/>               
        </vbox>     
        <vbox visible="@bind(not empty vm.selectedCategory)">
            <label value="@bind(vm.selectedCategory.name)" />
            <listbox model="@bind(vm.selectedCategory.items)">
                <template name="model">
                    <listitem>
                        <listcell label="@load(each.name)" />
                    </listitem>
                </template>
            </listbox>
        </vbox>
    </hbox>
</window>

java

package org.zkoss.jpa.examples.live;

import java.io.Serializable;

import org.zkoss.bind.annotation.Command;
import org.zkoss.bind.annotation.Init;
import org.zkoss.bind.annotation.NotifyChange;
import org.zkoss.jpa.examples.entity.Category;
import org.zkoss.jpa.examples.service.CommonDao;
import org.zkoss.zk.ui.select.annotation.VariableResolver;
import org.zkoss.zk.ui.select.annotation.WireVariable;
import org.zkoss.zkplus.spring.DelegatingVariableResolver;
import org.zkoss.zul.ListModel;
import org.zkoss.zul.ListModelList;

@VariableResolver(DelegatingVariableResolver.class)
public class ManualPagingCatViewModel implements Serializable{
    private static final long serialVersionUID = 1L;

    @WireVariable
    CommonDao commonDao;

    Category selectedCategory;
    ListModelList<Category> availableCategories;


    int pageSize = 10;
    int activePage = 0;
    int totalSize;

    public ListModel<Category> getAvailableCategories() {
        return availableCategories;
    }

    public Category getSelectedCategory(){
        return selectedCategory;
    }

    public int getActivePage() {
        return activePage;
    }

    public void setActivePage(int activePage) {
        this.activePage = activePage;
    }

    public int getPageSize() {
        return pageSize;
    }

    public int getTotalSize() {
        return totalSize;
    }

    public void setSelectedCategory(Category selectedCategory) {
        if(selectedCategory!=null){
            //refresh it to avoid org.hibernate.LazyInitializationException
            this.selectedCategory = commonDao.reload(selectedCategory);
        }else{
            this.selectedCategory = null;
        }
    }

    @init
    public void init(){
        totalSize = commonDao.sizeOf(Category.class);
        availableCategories = new ListModelList(commonDao.list(Category.class,activePage*pageSize,pageSize));
    }

    @Command 
    @NotifyChange({"totalSize","availableCategories"}) 
    public void paging(){
        totalSize = commonDao.sizeOf(Category.class);
        if(activePage*pageSize>=totalSize){//the data size was change since last paging, reysnc it.
            activePage = 0;//simply to first page
        }
        availableCategories = new ListModelList(commonDao.list(Category.class,activePage*pageSize,pageSize));
    }
}

answered 2014-05-08 14:38:33 +0800

gaucho
6

Dennis Answer works like a charm!

Thank you very much, you save my day!

Luis

answered 2014-05-08 18:36:08 +0800

terrytornado
9393 ● 3 ● 7 ● 16
http://www.oxitec.de/

Here is an online example with about 2.2 Million records. Paged on database.

http://zk-web.de/zksample2/

1. login
2. in Menu -> the last entry: Hibernate Statistics

best Stephan

PS: not optimzed for backward