I want to know the performance of this datatables in handling bunch of data

I want to know the performance of this datatables in handling bunch of data

wehpogiwehpogi Posts: 2Questions: 0Answers: 0
edited November 2011 in General
Is this good for handling more than hundred thousands of rows? i found out that this is a good project. but I am not still convinced to used it for my upcoming projects. my project will handle less than millions of data, then I'm afraid that when the number of entry of records reached the number I expected, it will slow down the system. so i just want to know the aswer of my question. Sorry for my bad english. and i hoping for your good reply. Thank you

Replies

  • allanallan Posts: 63,535Questions: 1Answers: 10,475 Site admin
    With Ajax source data loading and deferred rendering, then yes, client-side processing will handle 100'000 rows okay (obviously there will need to be a finite amount of time for sorting / filtering etc), but the deferred rendering feature of v1.8 should make all the difference.

    Here is an example of Scroller using 50'000 rows: http://datatables.net/release-datatables/extras/Scroller/large_js_source.html .

    If you want to make it as fast as possible though, and you might be dealing with >100'000 rows I would very much suggest you consider using server-side processing: http://datatables.net/release-datatables/examples/data_sources/server_side.html . I've seen this cope with 20 million+ rows without any problem :-)

    Allan
  • wehpogiwehpogi Posts: 2Questions: 0Answers: 0
    tnx for your answer @allan it gives me a big hope ;). I will felt a big regrets if it is 'NO'. because i like it very much from the start. anyway, Thanks for your answer!
This discussion has been closed.