Render and Cache"

From Documentation
m
m
Line 14: Line 14:
  
 
===Max Rendered Cell Size===
 
===Max Rendered Cell Size===
ZK Spreadsheet load cell data and also prune invisible cells as well when user scrolling sheet. The default setting is 8000, means client side will prune cells only when total cell number is more then 8000. Set by <javadoc directory="zss"  method="setMaxRenderedCellSize">org.zkoss.zss.ui.Spreadsheet</javadoc>
+
ZK Spreadsheet load cell data and also prune invisible cells as well when user scrolling sheet. The default setting is 8000, means client side will prune cells only when total cell number is more then 8000. Set proper size by <javadoc directory="zss"  method="setMaxRenderedCellSize">org.zkoss.zss.ui.Spreadsheet</javadoc>
  
 
Ideality, if browser could support, no prune cell would provide fest response effect, since all loaded cell no need to re-create. However, browser has limitation, if loaded cell number is outnumber then browser could handle, browser may become slow and unstable.
 
Ideality, if browser could support, no prune cell would provide fest response effect, since all loaded cell no need to re-create. However, browser has limitation, if loaded cell number is outnumber then browser could handle, browser may become slow and unstable.
Line 21: Line 21:
 
ZK Spreadsheet load cell data base on preloadRowSize/preloadColSize attribute when load sheet and scrolling.
 
ZK Spreadsheet load cell data base on preloadRowSize/preloadColSize attribute when load sheet and scrolling.
  
In theory, increase preload size will improve response time since cell data may preloaded, then no need to send request to server, it will also decrease the number of client/server communcation. However, if preload size is outnumber then needed, client side may need extra time to process extra data. For example, a screen display 50 rows * 30 columns, but preload size is 500 rows * 300 columns, then client side need to process many extra invisible data. Developer could adjust the preload size base on sheet's data size.  
+
In theory, increase preload size will improve response time. Since cell data may preloaded, then no need to send request to server, it will also decrease the number of client/server communcation. However, if preload size is outnumber then needed, client side may need extra time to process extra data. For example, a screen display 50 rows * 30 columns, but preload size is 500 rows * 300 columns, then client side need to process extra invisible data. Set proper preload size base on sheet's data size by <javadoc directory="zss"  method="setPreloadRowSize">org.zkoss.zss.ui.Spreadsheet</javadoc> and <javadoc directory="zss"  method="setPreloadColumnSize">org.zkoss.zss.ui.Spreadsheet</javadoc>
  
 
===ZUML===
 
===ZUML===

Revision as of 08:02, 5 April 2012

WarningTriangle-32x32.png This page is under construction, so we cannot guarantee the accuracy of the content!



Purpose

ZK Spreadsheet provide various setting

Client Cache

Use client cache will improve performance when user switch between sheet.

ZK Spreadsheet enable cache by default. To disable cache, use Spreadsheet.setClientCacheDisabled

Max Rendered Cell Size

ZK Spreadsheet load cell data and also prune invisible cells as well when user scrolling sheet. The default setting is 8000, means client side will prune cells only when total cell number is more then 8000. Set proper size by Spreadsheet.setMaxRenderedCellSize

Ideality, if browser could support, no prune cell would provide fest response effect, since all loaded cell no need to re-create. However, browser has limitation, if loaded cell number is outnumber then browser could handle, browser may become slow and unstable.

Preload Size

ZK Spreadsheet load cell data base on preloadRowSize/preloadColSize attribute when load sheet and scrolling.

In theory, increase preload size will improve response time. Since cell data may preloaded, then no need to send request to server, it will also decrease the number of client/server communcation. However, if preload size is outnumber then needed, client side may need extra time to process extra data. For example, a screen display 50 rows * 30 columns, but preload size is 500 rows * 300 columns, then client side need to process extra invisible data. Set proper preload size base on sheet's data size by Spreadsheet.setPreloadRowSize and Spreadsheet.setPreloadColumnSize

ZUML

Composer

Version History

Last Update : 2012/04/05


Version Date Content
2.3.0 April, 2012 Client cache/Max Rendered Cell Size
     


All source code listed in this book is at Github.


Last Update : 2012/04/05

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.