Guriddo » Topic: Grid performance limits

Grid performance limits

Guriddo
Grid performance limits

This topic has 4 replies, 2 voices, and was last updated 15 years, 8 months ago by OlegK.

Creator

Topic
October 29, 2010 at 4:59 pm #77468

benzocab
Participant

I haven't found any documentation on scalability of the jqGrid. I ran some tests and it seems that 5000 + records on the grid make it unusable because of the very very slow response time. From what I saw the maximum number of rows is somewhere between 500 and 1000 rows, to keep the grid usable.

Does anyone have similar experience? Is this expected? Is there any optimization I can do to improve performance? I'm currently using ajax to load the grid from a Sql Server database. I would like to implement subgrids as well. We're looking to be able to load at least around 10k rows at a time. Paging is not an option because we want the user to be able to compare data using grouping and summary rows.

Thanks,

Ben
Creator

Topic

Viewing 4 replies - 1 through 4 (of 4 total)

Author

Replies
October 30, 2010 at 1:34 am #96460

OlegK
Participant

Hello Ben,

I don't agree with you. You should post the code example which you used for tests (including HTML code and the included JavaScripts) and write which web browsers and in which versions you used. Do you used gridview:true

November 1, 2010 at 3:47 pm #96488

benzocab
Participant

Oleg,

I did not use the gridview=true parameter because the documentation says that it's not allowed when using subgrids which we'd like to use to show detail rows for each total. I can probably get around that, and will try to implement in the next day or two to see if this flag will make a difference.

As far as the loading all the data on the grid, yes, we can do the aggregation in the back end, but our back end is already doing some heavy processing, and the idea was to get a control that will handle the grouping and summation on its own will all the results there. We understand there's a limit, but my expectation was that the limit would be in the 10k range and not the 1k range.

Here is the JS code for my app:

grid.jqGrid(

November 3, 2010 at 9:42 pm #96517

benzocab
Participant

I did try “gridview=true” setting and it did seem speed up the grid, but not enough to make it usable for large amopunts of data. Not sure if anyone else has any other ideas.

November 4, 2010 at 12:30 am #96518

OlegK
Participant

All the experiments just shows that you should do paging on the server side. I can not understand the argument “our back end is already doing some heavy processing”. On the server side one implement all operations in compiled and optimized code, so you will have at least 1000 times better performance. Moreover the server can cache the results which can improve the performance also very much. With intelligent paging on the server side you will be without any problem be able to work with at least 100000 rows of data.

Best regards
Oleg
Author

Replies