Slowness due to validateCells function more than 300 rows

robert.shay · January 19, 2017, 5:17am

we have more than 300 rows of data(alteast 8 columns), while saving we called validateCells function (to validate cell ‘validtor’ with regex).

Due to validateCells function we are facing slowness (>3min) of time.

aleksandra_budnik · January 19, 2017, 7:09am

With this dataset 300x8 3 minutes for validation is extreme. Can you create a Fiddle where I will be able to check what causes this exactly?

robert.shay · January 25, 2017, 11:33am

Hi Aleks,

I am creating fiddler for this case. Will update you shortly

robert.shay · January 25, 2017, 12:23pm

Hi Aleks,

http://jsfiddle.net/9dczw3pk/51/

here, why validateCells callback is triggered foreach cell, it suppose to be called only once.

aleksandra_budnik · January 25, 2017, 12:52pm

Hi Robert,

It’s the same solution as for the second issue with misaligned headers - http://jsfiddle.net/handsoncode/pvsx2j4v/ updating the version fixes the issue.

Does it work for you as well?

robert.shay · January 27, 2017, 5:38am

Hi Aleks,

In chrome browser validateCells taking 600ms whereas in IE it takes 2500ms (4 times higher).

Unfortunately we are using IE only. few cases browser hangs

aleksandra_budnik · January 27, 2017, 8:34am

That is totally true, IE always worked slower.
I will mark this issue as an improvement suggestion.
I believe that there is something that we can do to make it work faster.