Performance Improvement with fnGetPosition & fnUpdate with > 100 Rows

Performance Improvement with fnGetPosition & fnUpdate with > 100 Rows

jDevC2ITjDevC2IT Posts: 3Questions: 1Answers: 0
edited October 2013 in DataTables 1.9
I'm thinking I'm missing something. I have 100 rows and 9 columns. I update each row using 'fnGetPosition' followed by 'fnUpdate' at 15 second intervals. Relatively speaking the freeze is tolerable but i'm wondering if there's improvements to be had using some others means to update. Goal is to remove the freeze all together. For example..

1. Use two js arrays, one for the new changes, other for the prior, compare and only update those rows that have changed?
2. Use the above method but only update cells that have changed?
3. Use some feature to offload the process that freezes the page during updates until the updates are complete?
4. Use an entirely different method all together?

Been some talk of it here on the forums but I'm hoping for something clear and definitive that might augment my approach for a performance gain.

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,470 Site admin
    What does your fnUpdate call look like? Are you passing the forth parameter as false to tell it to not redraw (please link to a test case as noted in the forum rules).

    Allan
  • jDevC2ITjDevC2IT Posts: 3Questions: 1Answers: 0
    Unfortunately I'm behind a firewall and on a private network. However, made the changes you suggested and appears that was my issue. Thanks for the help and apologies for not being able to abide by the rules. Thanks again!!!! This was big.
This discussion has been closed.