When trying to view an email record directly from sys_email, if the "view' that is used contains the Email Log section the record takes a long time to open. The use of the Email Logs related list queries all of syslog (and any shards as required), looking for any entry with a source that matches the email record requested. When an instance has a large syslog table(s), this can take a long time to execute and allow the record to open.
Steps to Reproduce
- Locate an inbound email that has been processed by some inbound actions (this is the best way to see log entries, but any inbound or outbound email could be used).
- Ensure that you have the Email Log section added to the View for that record. (For example, if you are using the Sent View view, add the Email Logs section so that when you open a Sent email, you see it on the record form.)
- Open the email record and wait for it to load.
- Switch the same email to a view that does not have the related Email Logs section attached.
Note the difference in load times.
(Note: This is difficult to do as you need large syslog tables/shards to see the full impact.)
Remove the Email Log embedded/related list from the sys_email form.
Related Problem: PRB588444