FpQuery said 7 years, 4 months ago:
I have a huge grid with 1000 rows and 25 columns. I also have cell spanning for almost all the rows and columns in the grid. Because of this it takes around 90 seconds to load the page, which is quite unacceptable. So in the quest to increase the performance, i went thro’ the document provided by FarPoint which suggests 4 measures to improve the performance. Going by the document, I have disabled ViewState
FpSpread1.ActiveSheetView.IsTrackingViewState = false;
I cannot use Sessions and SQL server state management for my project. So I am loading data for each page request. But inspite of this, there is no improvement in performance.I am also setting the RenderCSSClass property of the Spread to True.
I noticed one more thing. if i set the EnableClientScript property to false, the performance is amazing and the screen comes up in 8-9 seconds!! But that performance comes with a price. as soon as i set the EnableClientScript to false, the scroll bars disappears, the grid loses its default height(which i have set to 450px ), and the first column in my grid(check box column) has gained 2-3 times its original width. Apart from this, if i click on any cell on the grid, post back happens and my grid loses all its data. I tried setting
FpSpread1.ActiveSheetView.AutoPostBack = false;
but alas, the cell click event is still trigerred!
So can you please suggest some ways to improve the performance. I am using 2.5.2001.2005 version
scotts FP said 7 years, 4 months ago:
Part of the reason it is taking a long time for the page to render, is you are creating 100 checkbox objects on the rendered page. There is nothing in the Spread to help you render 1000 checkbox objects on a HTML page any faster. The only way to make this page render faster is by setting the PageSize to a smaller number.
Setting the EnableClientScript property to False is doing what it is suppose to. No scripting is turned on for the spreadsheet object, so all the columns will be set to see the widest text and the height and width of the Spread will change so there is no need for a scrollbar on the Spread. Also, clicking on a row will cause a postback to recreate the object with the selection on the correct row. And double clicking on a cell will cause a postback to get the editors for all the cells in that row.
FpQuery said 7 years, 3 months ago:
I removed the checkbox column but still i see no improvement in the performance.
Can you please suggest me anything which may help me in this regard. One more thing; I am making use of cell spanning to span cells in my grid. Is that by any chance eating up the time?
scotts FP said 7 years, 3 months ago:
Could you post a small zipped project reproducing the issue you are seeing for us to debug? Setting up spanned cells in the Spread will cause the Spread to take longer to render, since Spread has to find all spans to store them client side for use when the user navigates or edit cells in spans.
You must be logged in to reply to this topic.