Broadcast screen slow to open
We are experiencing an issue with there Broadcast screen for a report can take a very long time to open. It seems to be proportional to the number of broadcast schedules configured and the number of historical events.
Looking at the server logs, I've traced it back to a query that seems to run for each Broadcast schedule:
SELECT EventId, EventTypeCode, GMTDateTime, IpSource, SessionId, FinancialTransactionValue, FinancialCommission, FinancialDestinationValue, FinancialTaxValue, EventTime, EventDate, EventCode, EventData, ReferenceId, UnitId, TomcatSessionId, ReasonCode, ReasonDescription, ContentId FROM EventArchive WHERE GMTDateTime >= 20171209013729 AND GMTDateTime <= 20180123022156 AND EventTypeCode != 'SYSTEMTASK' ORDER BY EventId;
In our case this can take a while to run, and returns 184,000 rows!
We are seeing this on 7.4 build 20180208
Is there any fix for this issue forthcoming?