Send Email for multiple users

Question

Hi Experts,

We have a portal form where more than 5,000 plus users can be expected to submit a doc at the same time. So let me explain the flow

multiple users login to health insurance website --> create a new request and for every submitted request i need to send an acknowledgement email to them .

The email task is handled by our another application that reads the records from a table and on insertion of records it sends email.

Now  please advice an optimize approach of how to insert records into the email table if at the same time multiple requests can be expected. The portal will supply all the parameters like username.email address just looking for a way to handle multiple users smoothly without any performance issue.

Thanks

Answer 1

how to insert records into the email table

Just insert the data; where is the issue with it?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Hi Sir,

Thanks for the feedback. Am concerned with multiple user performing inserts at the same time. I hope it won't create any performance issue.

Answer 3

We fire a few thousand record per second into one table without issues.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]