search panes recursive error? 150k rows

search panes recursive error? 150k rows

sstar955sstar955 Posts: 2Questions: 1Answers: 0
edited March 20 in Free community support

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

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin

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

    Allan

  • sstar955sstar955 Posts: 2Questions: 1Answers: 0
    edited March 21

    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.

  • kthorngrenkthorngren Posts: 21,336Questions: 26Answers: 4,951
    edited March 21 Answer ✓

    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

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin
    Answer ✓

    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

Sign In or Register to comment.