Hi,
We have in place a mail system.
Basically mails (with the corresponding html content) are saved into a table "MAIL_TABLE" (as an example), and then there is a process in place that will gather the data from that MAIL_TABLE to generate mails for the apex_mail_queue.
So, we use in that process the apex_mail.send, to generate all the emails, and afterwards we do a .push_queue.
We are talking about 300-500 tops. But the whole process until it finishes sending the emails takes 10-15 minutes, being the last one sent at the very end. Is this normal?
Is there anything we could do to make this work faster?
I am not sure if could be the process, or a problem in the server starving for some resource and thus why is slow.
But if anyone could hint me, or help me to try to pinpoint and how to pinpoint the issue, I would really appreciate it.
To clarify, the process that is taking the 10-15 minutes is specifically the .push_queue, to send all the 300-500 mails. And it happens several times a day, but not all the times that is executed.
Thanks and regards!