Filter performance

Filter performance

norglawnorglaw Posts: 9Questions: 0Answers: 0
edited June 2013 in DataTables 1.9
Hi,

I developed a page with 3000 lines, and 19 columns displayed in a datatable.
Global and column filtering with columnFilter are enabled.
With deferRender, the page loads in 3-4 seconds and that's fine.
However the filter search is too slow : 3 seconds for a select filter, and it's not possible to write more than one letter per second in text filter.
I posted test case files on my server : http://www.atefpro.fr/test-case/

I just modified Datatable.js function _fnLoadState pour cookie management.


Thx for helping !
Alban

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,470 Site admin
    That is very slow. It might be your row callback function. Try removing that and see if it helps performance?

    More generally, I'd try disabling features until you find the one that is really slow. If its a core DataTables feature, let us know!

    Allan
  • norglawnorglaw Posts: 9Questions: 0Answers: 0
    Thx Allan,

    Impossible to find a key feature slowing the whole search process.
    I sent you a private message.

    Alban
This discussion has been closed.