When we click on any column header for sorting in grid(WebHierarchicalDataGrid) getting following error
Server does not respond.
We set callback timeout as follows
grid._callbackManager.setTimeout(300000);
This issue occurs only we have number columns with good amount of data.
Grid's OnColumnSorted event has code that fetch data based on clicked column for sorting.
Is there any limitation of grid like number of columns or specific column type are not supported or limitation of amount of data (size in KB or MB).
Kindly provide solution ASAP.
Hello Kalpesh,
There are no set limitations, however it is expected that at some point there will be issues handling enormous sets of data. In order to get more insight could you explain why do you fetch data on columnSorted event since at that time data is sorted and is available ? Obviously this code in columnSorted is taking too long to execute and as expected you receive a Server does not respond alert on the client.
I suggest that you review and minimize it and also rebuild this part of your application if you do not really need to fetch data on columnSorted event.
I hope this helps.
We have scenario as follows
1. When page load first time, grid loaded with records according to Page Size and Sorted column
Records will be fetched according to page size and sorting column set from the database, e.g only 100 records fetched out of 100000 records with sorting column.
2. Now user click on any column in grid to sort record
First 100 sorted records fetched from the database, and same bind with grid. So each time whenever you do sorting or paging we have database round trip to fetch records.
That's why we are fetching data in columnSorted event.
Thank you for clarifying. However this does change the situation that obviously your code is hard to execute and results in late response from server, if every time you do sorting the code fetches 100 out of 100 000 records.
If you need further assistance please feel free to share your code with us for investigation.
Hello,
If you have any further questions on the issue, please let me know.