Emailed DMI Reports Generated Multiple Times Unnecessarily
It appears when a scheduled DMI report is emailed at a given time to multiple recipients, DC-RUM generates the same DMI report once for each recipient and then mails them out individually. This seems like a waste of processing power and can negatively affect performance especially if the DMI is complex and/or sent to many people.
Is it possible to have a scheduled DMI report generated once but emailed to multiple recipients?
Phil,
CAS/ADS server does not detect that particular DMI report is scheduled to more than one user to be emailed at the same time to aggregate the mailing. The only workaround that we can imagine is having "group" fake users with distribution list emails assigned for this purpose.
Have you already experienced performance degradation when many "single" emails are sent, or you're just asking proactively?
Hi Adam,
Thanks for you response.
We have some quite large reports that are emailed each night to multiple people. Because of the sheer volume of data being displayed on the DMI they can take a few minutes to produce each report. If that's going to 20 people, that's a fair amount of unnecessary processing that the CAS is doing. We have experienced minor degredation to performance at the time the DMI's are generated.
Thanks for your recommendation. It just seems like a waste to have the CAS generate the same DMI multiple times. You could imagine if a report is being sent to 1,000 people each night, even a small one would cause performance degredation.
Phil,
Indeed when the report is scheduled to i.e 20 people then the data is taken from DB only once using SQL query but then it's composed in the form of the report as many time as many separate schedules we have.
Per short discussion with Development it may introduce some load but not very high.
I would recommend to use group emails and log "aggregation" enhancement.
