slow spreadsheet problem

asked 2013-02-06 17:35:46 +0800

DonDiegoDellaVega
0

Hi all,

I use ZK spreadsheet and meet a big problem of slowness when I use it :
My excel source file contains about 30,000 rows * 40 columns. To avoid overloading the spreadsheet, I make a pagination system (500 displayable rows each time * 40 columns).

There are two problems with slow :
- the first delay occurs when I scroll down to see my 500th line: at least 8 seconds to load before I can see the last line (for the first scroll)
- the second problem, much more painful is that when I start to scroll on a page, and then I want to pass on the next page, the calculation takes almost 30 seconds (2 seconds if I didn't scroll on first page !!)
Note : I did tests with six columns, and it is much faster (instead of 30 seconds for case 2, it takes approximately 6 seconds, but I need to see all columns).

My spreadsheet configuration :
preloadRowSize="500"
preloadColumnSize="45"
clientCacheDisabled="true" //I have only one page
maxRenderedCellSize="22000" //I try with 8000 and same problem
maxcolumns="50"

Do you have any ideas for me to optimize the spreadsheet?

thanks a lot (and sorry for my bad english but it's google who translate for me :) )