Answers

• Győző Posts: 3Questions: 1Answers: 0

  August 2019

  Another argument would be the considerably high cost of calculating recordsFiltered response field.

  Actually, it means all matching records should be filtered and then most would be neglected on the server-side because of paging. Unfortunately, the full-text index cannot benefit from start and length parameters either.
• colin Posts: 15,240Questions: 1Answers: 2,599

  August 2019 Answer ✓

  Hi @Győző ,

  If you've only got a few thousand records, then client side should be fine. It would be worth trying it out seeing if the performance is adequate. This section of the FAQ should also help, it discusses various techniques to improve performance,

  Cheers,

  Colin
• Győző Posts: 3Questions: 1Answers: 0

  August 2019 edited August 2019

  So for the record, let me share how I resolve my issue. It might help others.

  Unfortunately, I was totally obsessed with the server-side feature but what I was really looking for is simple ajax. I put a separate search input text box on the page of which event handler manages when the table content should be reloaded:

          var dataTable;
          $(document).ready(function() {
              dataTable = $('#sources').DataTable( {
                  "ajax": {
                      "data": function ( d ) {
                                  return JSON.stringify({"query": $(' #input').val()}); }
                              }
                      });
  
              var typingTimer;
              var doneTypingInterval = 700;
  
              $('#input').on('input', function() {
                  clearTimeout(typingTimer);
                  if ($('#input').val()) {
                      typingTimer = setTimeout(dataTable.ajax.reload, doneTypingInterval);
                  }
              });
  

  This way I have full control over when to fetch new data from backend (ie. when the main search term is changed) but all the rest (paging, ordering, further search in the result maybe) can be done on the client-side.