Slow performance in PAfE
Posted: Fri Mar 27, 2026 5:28 pm
Hi All,
I am currently testing the performance of the PAfE reports. Below is a simplified simulation of the report:
Columns A to D → Excel formulas referencing below set of columns (e.g., A1 = G1, B1 = H1, etc.)
Columns G to J → Values copied from below set of columns and pasted as static values
Columns K to N → =IF(range=1, DBRW(...), 0)
range is a named range scoped within the sheet
Note: The Excel calcualtion is Manual and not automatic and above copy-paste happens after running a macro.
The last set of columns (K to N) contains a large number of cells, and I suspect this is contributing to the slow calculation time.
This setup was performing well on-prem with PAfe, but it is significantly slower on the cloud.
Is there a way to eliminate the IF condition and use direct DBRW calls instead, or any recommended approach to improve performance in this scenario?
Why are PAfE reports slow on cloud than on prem?
Thank you.
I am currently testing the performance of the PAfE reports. Below is a simplified simulation of the report:
Columns A to D → Excel formulas referencing below set of columns (e.g., A1 = G1, B1 = H1, etc.)
Columns G to J → Values copied from below set of columns and pasted as static values
Columns K to N → =IF(range=1, DBRW(...), 0)
range is a named range scoped within the sheet
Note: The Excel calcualtion is Manual and not automatic and above copy-paste happens after running a macro.
The last set of columns (K to N) contains a large number of cells, and I suspect this is contributing to the slow calculation time.
This setup was performing well on-prem with PAfe, but it is significantly slower on the cloud.
Is there a way to eliminate the IF condition and use direct DBRW calls instead, or any recommended approach to improve performance in this scenario?
Why are PAfE reports slow on cloud than on prem?
Thank you.