Page 1 of 1

Jiwa Grid performance issue with filter

PostPosted: Thu Mar 31, 2022 12:57 pm
by perry
Hi All,
v7.2.1

I have only tested on a list maintenance page but I believe this related to JiwaGrid control.

In short, it take significantly longer time to read a list if user has a filter on the grid.

To test, I created about 800 categories (in_category1), load the form and it finishes in 15s. Then apply a filter, click refresh and it takes 30s.
It also looks like the more specific the filter is, the longer time UI becomes responsive.

I feel like grid control is applying the filter to the entire list every time a row is added.
do you think this is something "fixable"?

Thanks!

Re: Jiwa Grid performance issue with filter

PostPosted: Thu Mar 31, 2022 5:21 pm
by SBarnes
The Jiwa Grid extends the Farpoint grid which is now known as Grape City's Spread for Windows Forms and I think the filter functionality is probably being totally controlled by the original control, the Farpoint control.

The product documentation for version 8 is here https://help.grapecity.com/spread/Sprea ... guide.html which may be of some help.