Hello, we currently have around 180,000 contacts in a recipient list for our newsletter. The issue is that the Recipient List Overview page on the admin side takes over two minutes to load (after a clear cache) and around 10-15 seconds with a cache hit. With some investigation, we found that the issue lies with the statistics (Recipient Statuses) for the number of receiving, bounced, and unsubscribed contacts where there is an individual SQL query to the database for each individual contact to the EmailLibrary_EmailSubscriptionConfirmation
table. This results in over 360,000 individual queries to the database. Even with an index, the page still loads over 2 minutes. Is there any way on our side to improve this?
Thanks!
Matthew
Environment
- Xperience by Kentico version: [29.7.3]
- .NET version: 8
- Execution environment: Private cloud