0

Load Large Datas in the Listbox (ie >20000 datas)

asked 2010-12-29 00:06:57 +0800

gururajan gravatar image gururajan
6

Hi all,

I need a great help. I want to load nearly 20000 records to the listbox.
It is taking more than a minute. But i have an image on each rows.

I need load 20000 datas with in 5 seconds.

Your help is very much appreciated.

Thanks
Guru

delete flag offensive retag edit

3 Replies

Sort by ยป oldest newest

answered 2010-12-29 03:51:33 +0800

terrytornado gravatar image terrytornado flag of Germany
9393 3 7 16
http://www.oxitec.de/

Is paging of the data not possible?

link publish delete flag offensive edit

answered 2010-12-29 05:46:55 +0800

gururajan gravatar image gururajan
6

Hi thanks for your presence on this.

I dont want paging. I want a minimum of More than 5000 records in single page that can be viewed over vertical scrolling

we tried live Data scrolling by keeping rows = 30 , Even it takes 28 seconds to load first 30 Records.

In my application am using Hibernate to get data from database to the ZK list box.

and i want 5000 Records per page to display. In best performance.

Assist me on the same.

Thank you so much on this.

Please have a look on this

<listbox id="radStudy" checkmark="true" model="@{myList}" style="font-size:10px;" multiple="true" rows="30" fixedLayout="true" visible="false" width="1550px">

link publish delete flag offensive edit

answered 2010-12-29 07:46:35 +0800

robertpic71 gravatar image robertpic71
1275 1

>> we tried live Data scrolling by keeping rows = 30 , Even it takes 28 seconds to load first 30 Records.
Are you sure that only the UI is "slow"? Is the picture a from the database?

The are 2 problems handling huge data:
DAO/Model
depending on your model/DAO-tier all data is loading for the first time
--> there is need for paging

ZK, next problem
Your model is smart enough to handle paging but ZK creates all required
(empty) UI elements at once

Note: I've write paging, but it's possible to use paging models for livescrolling.

How you can solve this issue:
- First you need to know, how long your model needs to load (i've loaded more items in less time)
- make your model ready for paging (if the whole loading time is to slow)
- implement your onwn paging/scroll logik
--> Stefan (aka terrytornado) has implemented a paging model layer in his demoproject

other solutions:
--> there is also a feature in the ZK-EE-Edition for hugedata handling

--> create a growing model for livescrolling and pagemodel like this.
[You can find some code for the growing model in the forum, i did not find the time to implement a JPA variant for this....]

--> if your loading time is bad, you should exclude the images from the model and create a url-source instead

/Robert

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2010-12-29 00:06:57 +0800

Seen: 629 times

Last updated: Dec 29 '10

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More