Jiwa Grid performance issue with filter

Discussions relating to plugin development, and the Jiwa API.

Jiwa Grid performance issue with filter

Postby perry » Thu Mar 31, 2022 12:57 pm

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!
Perry Ma
S. Programmer
Lonicera Pty Ltd
http://www.lonicera.com.au
perry
Frequent Contributor
Frequent Contributor
 
Posts: 173
Joined: Mon Oct 27, 2008 2:26 pm
Topics Solved: 15

Re: Jiwa Grid performance issue with filter

Postby SBarnes » Thu Mar 31, 2022 5:21 pm

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.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1619
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 19 guests