i am sending emails to more than 1000 users at time ,
so i used a datatable to fetch email addresses from DB's table and then i loop over it voa foreach and then send it to each user via net.mail namespace's code
that's ok, Done
But problem is that it slows down the speed, it takes time to send a single line of data to such a heavy amount of users ,
So what is the appropriate way to improve performance , how to gain efficiency
Help !
tools : asp.net 3.5 (c#)
sql server 2008