Is there any way to speed up searchPanes when using the server-side approach?
Is there any way to speed up searchPanes when using the server-side approach?
lancwp
Posts: 103Questions: 23Answers: 1
in SearchPanes
Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
My record count is over 7,000 with 30 fields, which makes the table very slow to load—it takes about 20 seconds. To improve performance, I switched to a server-side approach. The table uses both searchPanes and searchBuilder. While searchBuilder performs well, using searchPanes causes significant lag, especially when loading more than 20 fields in searchPanes, which also takes around 20 seconds. This essentially negates the benefits of switching to server-side processing. Is there any way to speed up searchPanes when using the server-side approach?
Answers
Assuming you are using the Editor server-side libraries, enable the debug mode by adding
->debug(true)before the->process(...)call (for PHP - the .NET and Node.js have the same method, different syntax). Then have a look at the JSON returned when the browser loads that page. Can you show me that JSON please?Allan
JSON output
https://47.243.26.235/wp-content/uploads/new.html
Thanks
The JSON response has over 7000 rows of data. Did you enable server side processing with
serverSide: true?I don't see the expected response parameters, like
draw, in the response. More confusing to me is I see the SearchPanes and SearchBuilder SSP response parameters. I wouldn't expect to see these with client side processing. Please post your Datatables init code.Kevin
yes, serverSide: true
https://47.243.26.235/wp-content/uploads/TEST.TXT
@kthorngren Can you help me check it? Thank you
Can you link to the actual running page please? As Kevin indicated, the JSON response has over 7000 rows, but possibly you got that via a GET request?
I'd need to see a running example to be able to offer much help.
Thanks,
Allan