Filter search panels performance issue, slow, laggy

latinunit

https://live.datatables.net/muzeriza/5/edit

I have 1k records with a few filters, applying the filters are very laggy with seconds, searching on the text box is also very laggy, just wondering what can be done? and how do you deduct where the bottleneck lies?

On my sandbox, even with 15 records, the filter is slow https://somup.com/c0nbbZxWBg

and if you check performance on the datatables examples, is also very slow

https://datatables.net/extensions/searchpanes/examples/performance/cascadeViewTotal50k.html

latinunit

bump

allan

Yes, cascade is a slow operation. Without it is should be really quite fast, but as soon as the cascade option is enabled, the number of calculations needed does way up.

The performance in the example is poor. I think we should be able to do better than that with 50k rows. The way to do that will be to use the profiling tools in the browser. I can't promise a timeframe for that, but it is an important point that needs to be addressed.

Allan

latinunit

I set the cascadePanes: false and is super fast now, but then the values don't get calculated when applying the filters.

Just wondering, what does cascade actually does? apart from hiding the records from filters when not meeting filter criteria?

I also disabled the viewTotal and that also speeds up filtering by ALOT, but how can I remove the calculated values then as they no longer update.