Render and Cache
ZK Spreadsheet provide various setting
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 when user scrolling. The default setting is 8000, means client side will prune cells only when total cell number is more then 8000. Set by Spreadsheet.setMaxRenderedCellSize
Ideality, if browser could support, no prune cell would provide best 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 act slow and become unstable.
ZK Spreadsheet load cells data base on preloadRowSize/preloadColSize attribute.
|2.3.0||April, 2012||Client cache/Max Rendered Cell Size|
All source code listed in this book is at Github.