search panes recursive error? 150k rows
search panes recursive error? 150k rows
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)
This question has accepted answers - jump to:
Answers
With 150k rows I'd use server-side processing, no question.
Allan
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.
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
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