Speed up "Mass Mail"

This topic is locked

Speed up "Mass Mail"	10/28/2010 12:10:50 PM
ASPRunnerPro General questions
P Philip author Hello ASPRunner 6.2 I send users an e-mail after a new record has been added. I do that with an After edit event. The mail includes some details from the added record and it's sent to all adresses picked from a list by using while not eof .... data.MoveNext wend This works perfectly BUT it's extremly slow depending on the number of adresses (actually 150). This takes about 30 seconds before a user can enter next record ... QUESTION: is there any idea / way to speed this up? Regards Philip


	Sergey Kornilov admin 10/28/2010
	Email is slow by design. There are a few things you can do to speed the things up: Build a long list of CC or BCC email addresses and send them all at once (or in batches) or Instead of sending emails right away add all of them to another database table (email queue) and send them using a separate email script. Here is an example: http://www.asprunner.com/forums/topic/14795-sample-script-to-send-email-on-timely-fashion/