Hello
Not sure if you are going to be able to help, but thought I would ask your advise anyway. I have a blazor server app published to Azure. The core of the app is a pivot table that displays processed data. I am doing this data processing on a high spec SQL Server box and I know that the data comes back quickly (1-2 seconds) and I rollup the data where possible so that the pivot table is dealing with small amounts of data (typically 20-100 rows with say 5-10 fields).
The speed is fine when published, just not really snappy. In particular if I switch from say Pivot Table to Pivot Chart then it takes close to 5 seconds to render the chart. In the dev environment (local machine) this is pretty much instant.
I have tried scaling up the web-app resources with more memory etc, but nothing I do seems to make any difference. Do you have any pointers/suggestions on what the bottle neck(s) might be. I appreciate this is not your core concern, so any tips would be great.
Thank you