We are using paged DHTMLX grid. We observed that the performance degrades very severely when the number of rows is increased.
We have around 30 columns and the data is mostly decimal values.
When we have around 10-15 rows per page, the ‘next page’ action works almost instantly.
But when the number of rows is increased to , say, 150, the same next page takes around 8 seconds, which is unacceptable to the end users.
Another interesting observation - First time, when we go to page 2 ( for example), it takes 8 seconds. Then we come back to page 1. Again, when we go to the same page 2, it takes only 2 seconds. But, if we go to a new page ( say, page 3), it again takes 8 seconds. We found this behavior to be very surprising.
Can you let us know some pointers which we can look into?
Is the performance as per expectation or can it be improved?