Slow Performance when Validations in Editable Grid

Hi, 

I have an editable grid with 5 columns  with first column has labels which is read only and remaining 4 columns are editable with  more than 50 rows.

There are multiple validations executed on each cell like Totals,Subtotals are calculated, Also each row has a different set of validations executed. All are inline validations.

Performance for few grids less than 20 rows is better, but as the number of rows increases in other grids performance is not good it shows "working....." for few seconds when ever each cell is edited.

Am using expression rules to execute validations, i cannot use decision tables in my use case.

Please suggest any inputs which makes performance better.

 

 

Thanks,

Karthik

  Discussion posts and replies are publicly visible

Parents
  • Hello Karthik,

    We were also facing performance issue due to many validations and logical filtering, we are now moving that validation and filtering in DB.

    1. If possible you can perform some validation on DB itself.
    2. By defining the batch size you can minimize the performance issue but not to full, you have to look into your expression rule and try to optimize it, if not then its better to do some validation. at DB side.

    Thanks
    Sahil
Reply
  • Hello Karthik,

    We were also facing performance issue due to many validations and logical filtering, we are now moving that validation and filtering in DB.

    1. If possible you can perform some validation on DB itself.
    2. By defining the batch size you can minimize the performance issue but not to full, you have to look into your expression rule and try to optimize it, if not then its better to do some validation. at DB side.

    Thanks
    Sahil
Children