Having a showrowfilter = true slows things down

[chaykMember]

Hi,

I have a grid having 89 columns but only 10 columns are shown and others are hidden. I made rowfilter for 5 columns of them using filterable properties. With having a rowfilter on my grid which is paging virtualized, the other functionalities such as having rowdetail or hide and show columns from user’s selection are going delayed. If I turn off the rowfilter, the response speed of rowdetail and show/hide columns is not bad. Is there some performance issue with having rowfilter functionality?

Thank you,

[Peter StoevKeymaster]

Hi chayk,

If you have 89 columns then you will have 89 widgets in the filter row. That will have impact on the performance. If some of your columns will be hidden, you may set the “filterable” column property to false. By doing this, the Grid will not create a filter widget for that column.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[chaykMember]

Thanks for your response. But as I wrote, I only uses 5 columns for filter row and other’s filterable property is set to false as you recommended. The response speed turns out to be bad as well. I use ver 2.8 for the reference.

[Peter StoevKeymaster]

Hi chayk,

Please, provide a sample which demonstrates your issue as we will have to test your scenario. In general, if an editor is created for each column, then you will have loading performance impact.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[vmanneParticipant]

Hello,

I have a similar issue as the OP. When I turn off filters

showfilterrow: false

, for my columns, performance increases *significantly*.

I have eight columns, that load initially and then additional columns are being shown/hidden from a dropdown checkbox list. When I turn off filters, it blazes through.

We’d like to use filters, however, performance is pretty bad. I’ve downloaded latest 2.8.2 and still the same issue.

Please advise.

Thanks.

[Peter StoevKeymaster]

Hi,

if an editor is created for each column, then you will have loading performance impact. It does not matter whether a column is hidden or not. Also make sure that you use beginupdate and endupdate methods when you call multiple methods or set properties.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[vmanneParticipant]

Hi Peter,

Sorry I bumped this thread. I don’t have editors as the OP. I should have opened a new thread to help clarify

Please see the new thread.

Thanks
Vik

[Peter StoevKeymaster]

Hi,

By editors I meant – filter editors so the thread is fine.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts