search panes recursive error? 150k rows

sstar955

https://live.datatables.net/haberobu/1/edit

when using search panes and 150k rows I get a maximum call stack error

Uncaught RangeError: Maximum call stack size exceeded
at Le (dataTables.min.js:4:32042)
at s (dataTables.min.js:4:25688)
at Oe (dataTables.min.js:4:33585)
at O (dataTables.min.js:4:6955)
at HTMLTableElement.<anonymous> (dataTables.min.js:4:7142)
at Function.each (jquery-3.7.1.slim.min.js:2:3335)
at ce.fn.init.each (jquery-3.7.1.slim.min.js:2:1800)
at ce.fn.init.$ [as dataTable] (dataTables.min.js:4:1300)
at B.fn.DataTable (dataTables.min.js:4:90852)
at new $ (dataTables.min.js:4:1196)

allan

With 150k rows I'd use server-side processing, no question.

Allan

sstar955

Is there any way to get it working client side on chrome? I really love the complex searches you can create with query builder and panes combined and I cant say I'm advanced enough on the backend to get all those features working with straight SQL.

kthorngren

Not sure what your backend is but this blog shows how to use the Editor server side processing libraries with searchPanes:
https://datatables.net/blog/2020/ssp-with-editors-libraries

If you use this option you will want to read the SP server side processing doc](https://datatables.net/extensions/searchpanes/serverside).

Kevin

allan

I'm sure there are client-side optimisations that can be made, but if I knew what they were, I'd have made them . Pull requests to optimise the client-side performance are most welcome.

Allan