Batch email sending status performance

D365FO
1

We are experiencing performance issues with the Batch email sending status page in D365FO. There is a huge number of records in the list which I suspect could be the reason. I have run the Email distributor cleanup, but kept 4 years of data due to policy. How can I see the number of records in the list (without download to Excel)? Could there be any other reason for the slow performance? We are running the D365 in the cloud.

2

Hi @kentrut and welcome to the Docentric community!

Since you have the clean-up option I can see that you are running the updated version of the Batch Email Sending Status table where the indexes were optimized and are optimal.

You can try to show the footer on the bottom of the Batch Email Sending Status form, which will display the number of records. To enable the footer, click on the three dots at the right-end of the table header, and select Show footer.

image
image1201×661 65.2 KB

Once enabled, the footer will show the number of rows present in the table.

image
image1205×120 1.67 KB

3

Thanks. I have activated the footer but the problem is that it limited to 25000 records. It will just show >25000.

There is a setting somewhere in the system to increase this number but I don´t know the consequences if it is increased.

Is there a limit, when the number of records in the Batch email sending status, will have a negative impact on the performance. Now it takes approx 5 mins to load the page!

4

Hi Kent,
by right-clicking on the form name, you can see the table name, as shown in the image below. You can then run the following SQL on the database:

SELECT COUNT(*) FROM SysOutgoingEmailTable;

This will return the number of records in the table. Please note that this table is part of the standard data schema and is not a Docentric table. If you need further guidance regarding performance or limitations, you may want to reach out to your partner or Microsoft support. Thank you for your understanding.

1 Like
5

We are exploring 2 possible options to improve user availability of the Batch email sending history since we can not remove more records:

  • Create a filter that automatically pops-up where you can filter on a Date range before entering the page. Similar to the Posted Sales tax inquiry.

  • Automatic filter for all users when entering the page with a limit of latest 90 days of records. Filter can then be adjusted once you are inside the page.

Any other suggestions or comments from the forum?

6

Hi @kentrut,

Your ideas sound good. Let us know how it goes!
We were also thinking that you could try one more thing - what if, for each user, you enter a filter, and then save that as a view? You would need to do this for every user once, but it might be helpful in the long run.