hi folks,
I have an app which is currently taking around 3 hours to run on the server. It does handle a large set of data so is to be expected but I would like to try and tune it to get the time down
The main purpose of the app is to calculate some expressions at a segment level so that we can use this for monthly trend as the size of the data we currently have in the dashboard is too large to have multiple months. So we include the current month plus aggregated old months so that users can see trends.
I have to load about 30 million client records and then calculate %'s at a grouped level so that these can be stored and loaded into the main dashboard
There are around 25 fields which we need to calculate the metric on.
I am using the SUM function and the GROUP BY to perform these metrics.
Is this the most efficient way to calculate percentages on large amounts of data?
Cannot post a QVW due to privacy 🙂
