0

performance issued at grid

asked 2009-06-27 03:37:58 +0800

ibsolution gravatar image ibsolution
468 1 1 6

updated 2009-06-27 03:56:54 +0800

hai,

how to check zk performance when showing 3492 record. i am using a grid component with pagingSize=50, i got a return about more or less one minute.

i query with database tool it very fast zero minute.

is there any solution

Regards,

Andy Susanto

delete flag offensive retag edit

9 Replies

Sort by ยป oldest newest

answered 2009-06-27 09:40:36 +0800

SergeTk gravatar image SergeTk
193 3

Is that every time you navigate to a new page or when it first loaded ???

Also how are you using paging ( session size managment hit db every time you navigate to new page) or for rendering reasons (hit db once)...

link publish delete flag offensive edit

answered 2009-06-27 14:06:02 +0800

ibsolution gravatar image ibsolution
468 1 1 6

hai,

yes every time i navigate it.

i am using a paging from zk.And every time i navigate it i am always use a query.

i am rendering a grid from query not using database layer.

is there any solution for me ?.

Regards,

Andy Susanto

link publish delete flag offensive edit

answered 2009-06-28 10:11:27 +0800

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

updated 2009-06-28 10:14:54 +0800

@ibsolution,

if you can change to a listbox have a look here:
Smalltalk

Stephan

PS: check the speed here: https://62.75.171.30/test/
usr/pwd = admin/admin
Customers have 120.000 records of testdata.

link publish delete flag offensive edit

answered 2009-06-29 01:32:39 +0800

ibsolution gravatar image ibsolution
468 1 1 6

hai,

you see that listbox have a better performance then a grid ?

and listbox have a feature sorting and paging too ?


Regards,

Andy Susanto

link publish delete flag offensive edit

answered 2009-06-29 21:19:07 +0800

YamilBracho gravatar image YamilBracho
1722 2

Andy you will get best performance if do the paging in the database server. Also check indexes in your data model...

link publish delete flag offensive edit

answered 2009-06-30 10:04:21 +0800

ibsolution gravatar image ibsolution
468 1 1 6

hai,

i solve my problem from smalltalk. btw i already use a paging

thanks for helping me,

Andy Susanto

link publish delete flag offensive edit

answered 2009-06-30 10:47:24 +0800

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

:-) Please leave a comment in the smalltalk.

Stephan

link publish delete flag offensive edit

answered 2009-07-01 07:27:54 +0800

ibsolution gravatar image ibsolution
468 1 1 6

hai,

@terrytornado

i am still using a grid component is that oke to write a comment ?, is ok will write it

Regards,

Andy Susanto

link publish delete flag offensive edit

answered 2009-07-01 10:05:58 +0800

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

updated 2009-07-01 10:07:48 +0800

:-)

Andy, you are right. Grid is not ListBox.
You can explain here your way for others.

thx
Stephan

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: 2009-06-27 03:37:58 +0800

Seen: 404 times

Last updated: Jul 01 '09

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