Using <CFMAIL query="myquery"> will clean your code up a little, but shouldn't make a difference to the actual performance, as all 7000 will be sent to the spool at the same time. Incidentally, have you checked that in fact all the emails are going, as I have come across instances when that many emails are spooled that a large percentage end up in undelivr. Not ascertained why, but some relays don't like it cos of spamming I guess.
-----Original Message----- From: Sandeep Shetty [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 13:49 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Mailing Lists question Hi, I have a question on large number of emails using cfmail. We are sending out HTML emails to around 7000 registered users. We are currently looping through cfmail tag using cfloop the required number of times and send out emails using our IMail server. Is there a better way of sending out this many emails? I have noticed that whenever this many emails are sent out the server processor usage reaches nearly 100%! and have seen that a process called dllhost.exe uses up nearly 60percent of the processor and uses large amounts of memory. Can sending out 7000 emails from coldfusion using a cfloop cause this problem. We use cf5. Our server has 1gig ram and good hard disk space. Any advice, suggestions or links would be most welcome Thanks in advance, Sandeep -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] DISCLAIMER: This e-mail is confidential and may also be legally privileged. If you are not the intended recipient, use of the information contained in this e-mail (including disclosure, copying or distribution) is prohibited and may be unlawful. Please inform the sender and delete the message immediately from your system. This e-mail is attributed to the sender and may not necessarily reflect the views of the patsystems Group and no member of the patsystems Group accepts any liability for any action taken in reliance on the contents of this e-mail (other than where it has a legal or regulatory obligation to do so) or for the consequences of any computer viruses which may have been transmitted by this e-mail. The patsystems Group comprises patsystems plc and its subsidiary group of companies. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
