Mass email generation speed needs improvement

macstalker@gmail.com

Hi there,

I noticed ACYMailing generates new email for every recipient despite email content stays mostly unchanged. That's huge spike in server load (5% normal vs 80% while sending) as we have to send 30k emails in 2-hour period once a week. Thus, we have to pay more for extra CPU cores just to keep website accessible while sending emails. And I'm not talking about CO2 emission 🙁

Is there any way to implement cache for dynamic plugins like Article? I'm aware that each email actually has unique content like tracking links and may include other user specific content. Any improvements in email generation speed would be much appreciated.

Thank you

jvstratum

Hi,

Do you already use the lates 9.7.0 version? In this version the size of emails built with our editor has been reduced by 25% on average, which should improve the sending speed.

Other then that I would reccommend to contact your hoster and check if they offer some kind of database caching. Database caching involves caching the results of database queries on the server, so that subsequent requests for the same data can be served quickly without having to re-run the query. This can improve the performanceby reducing the time required to fetch data from a database.

macstalker@gmail.com

jvstratum

Thanks for your answer. It's not about sending speed or letter size it's about generation toll on CPU. Ideally some kind of caching should be implemented. What's the point to generate identical letter thousands times if we can do it once and send it to all recipients.

mihha

The point is that each newsletter can be personalized and can include details that only a specific subscriber should or can receive