Start Building Professional
Web Apps Today

loading the grid performance is very slow with large data

Hi ,
I am using the dhrmlxgrid with DataProcessor, I have 40 columns in grid with 1500 rows.

1) I have used smartrendering to load the page, even though after using smartrendering the performance of grid is very slow and some of the rows itself not showing in grid in the middle of the rows. let me know how to improve the performance of the grid?

2)In our requirements, we shouldn't want to use pagination, so I have directly loaded the grid, after loading the grid, it performing very slow. In my case the number rows should not be more then 1500. So how do I improve the performance?

I am using DataProcessor for dynamic insert/delet/update operations and at index ==0 I am using cntr type.

/Thanks
Raj

>>even though after using smartrendering the performance of grid is very slow

The performance for such dataset must be fast enoug. In smartrendering mode the total height of grid doesn't matter, because only visible rows rendered

>>and some of the rows itself not showing in grid in the middle of the rows

Issue can be caused by using of custom row height.

http://dhtmlx.com/docs/products/kb/index.shtml?cat=search&page=1&q=3181&ssr=yes&s=row%20height

>> it performing very slow
Can you please exactly specify , which actions are to slow in such case.
Enabled smart rendering mode must be enough to achieve good performance

 

>> I am using cntr type
This is may be the reason of problem, cntr excell recalculates for each row during rendering and as result decreasing performance gained by smart rendering usage.

 

Hi,

Right now I am not using smartrendering, as I mentioned before that my application grid will have 40 columns and 1500 rows. this should not be more then this.

Pagination is not in our requirement, so we are not able to use pagination. And smart rendering is not suitable because cntr excell recalculates for each row, as you mentioned this leads to performance issue.

So I tried to use enableDistributedParsing mechanism, but still the performance wise it very slow, can u please guide me is enableDistributedParsing mechanism suitable for my application grid or do I need to use another mechanism which will improve performance?

If enableDistributedParsing is suitable to improve performance, then how do I use that?

If any other mechanism is there, please guide me?

/Thanks

Raj

 

>>So I tried to use enableDistributedParsing mechanism, but still the performance wise it very slow, can u please guide me is enableDistributedParsing mechanism suitable for my application grid or do I need to use another mechanism which will improve performance?

The distributed parsing will not improve situation, it just replace single time loading with multiple iterations.

The only way is to use SmartRendering mode, you can try to use Dynamic Smart Rendering instead of static one, it a bit faster.