RE: Email Questions
If the code inside of your CFMAIL tags are going to be run 70,000 times, I'd put a lot of effort into optimizing it. 1. The BCC idea is great. 2. Make sure you're not running any unnecessary queries inside of your CFMAIL 3. Take all the text in the body and place it into a variable such as #MailText# and then just do CFMAIL ... ... #MailText# /CFMAIL This will keep CFAS from parsing what's in between the CFMAIL tags 70,000 times. -- Original Message Follows -- Date: Wed, 11 Apr 2001 08:55:37 -0400 From: "Brian Peddle" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Email Questions Message-ID: [EMAIL PROTECTED] I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Questions
On the same topic, but a question(ish), I've thought about setting up a mailing list (listserv) and using CF to send one message to the listserv. I haven't put this in practice, but in theory you could set up the list to only relay e-mails from one account and then set up CF to send the e-mails using that address as the "from". Then you only send one e-mail from CF Server and let the listserv software handle all the rest. Has anyone put this into practice? Thanks! Hatton -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 10:00 AM To: CF-Talk Subject: Re: Email Questions Break your query up. Run all the email for the last names that start with the letters A-C, D-F, and so on. Run them one at a time. Finding a way to make your query results smaller and thus sending fewer emails ought to do the trick. - Original Message - From: "Brian Peddle" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 7:55 AM Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Questions
You might want to take a look at iMS POST SE at http://www.coolfusion.com/moreinfo.cfm?Product_ID=33. We just started using it and I am happy with it so far, and the support has been quite good. Bob -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED]] Sent: April 11, 2001 8:56 AM To: CF-Talk Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Questions
i have a DB of 49,000 addresses, and here's what i found: the machine in question is: CF 4.5SP2 IMail 6.0.5 SQL7.0 WINNT4.0SP5 512MB Ram dual PIII500 i can send 8,000 emails in less than 3 minutes. my application divides the total address count by 8,000 (don't forget the remainder) to figure out how many iterations there should be (9 in my case). then i CFLOOP to create 9 CFSCHEDULE entries (i run my emails starting at midnight) 4 minutes apart. takes 36 minutes to spool over all of them. i found if i try and send blocks of 10,000 CF freaks. for me, 8,000 was the magic number. i'm sure it could be more exact but i was trying to keep it simple :). -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:56 AM To: CF-Talk Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Email Questions
Have you found that you needed to define the port number in cfmail in order for it to work? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com - Original Message - From: ""Dylan Bromby"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Wednesday, April 11, 2001 2:36 PM Subject: RE: Email Questions i have a DB of 49,000 addresses, and here's what i found: the machine in question is: CF 4.5SP2 IMail 6.0.5 SQL7.0 WINNT4.0SP5 512MB Ram dual PIII500 i can send 8,000 emails in less than 3 minutes. my application divides the total address count by 8,000 (don't forget the remainder) to figure out how many iterations there should be (9 in my case). then i CFLOOP to create 9 CFSCHEDULE entries (i run my emails starting at midnight) 4 minutes apart. takes 36 minutes to spool over all of them. i found if i try and send blocks of 10,000 CF freaks. for me, 8,000 was the magic number. i'm sure it could be more exact but i was trying to keep it simple :). -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:56 AM To: CF-Talk Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Questions
no. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 6:43 AM To: "Dylan Bromby"; CFTALK Subject: Re: Email Questions Have you found that you needed to define the port number in cfmail in order for it to work? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com - Original Message - From: ""Dylan Bromby"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Wednesday, April 11, 2001 2:36 PM Subject: RE: Email Questions i have a DB of 49,000 addresses, and here's what i found: the machine in question is: CF 4.5SP2 IMail 6.0.5 SQL7.0 WINNT4.0SP5 512MB Ram dual PIII500 i can send 8,000 emails in less than 3 minutes. my application divides the total address count by 8,000 (don't forget the remainder) to figure out how many iterations there should be (9 in my case). then i CFLOOP to create 9 CFSCHEDULE entries (i run my emails starting at midnight) 4 minutes apart. takes 36 minutes to spool over all of them. i found if i try and send blocks of 10,000 CF freaks. for me, 8,000 was the magic number. i'm sure it could be more exact but i was trying to keep it simple :). -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:56 AM To: CF-Talk Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Questions
Check out iMS from coolfusion.com ~ Justin -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:04 PM To: CF-Talk Subject: RE: Email Questions On the same topic, but a question(ish), I've thought about setting up a mailing list (listserv) and using CF to send one message to the listserv. I haven't put this in practice, but in theory you could set up the list to only relay e-mails from one account and then set up CF to send the e-mails using that address as the "from". Then you only send one e-mail from CF Server and let the listserv software handle all the rest. Has anyone put this into practice? Thanks! Hatton -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 10:00 AM To: CF-Talk Subject: Re: Email Questions Break your query up. Run all the email for the last names that start with the letters A-C, D-F, and so on. Run them one at a time. Finding a way to make your query results smaller and thus sending fewer emails ought to do the trick. - Original Message - From: "Brian Peddle" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 7:55 AM Subject: Email Questions I posted this last night but I didn't see it post. I apologize if it comes through twice. I currently send out a weekly newsletter to a growing database of 70,000 right now. I currently query the DB and loop the results and send out an email to each member. It takes CF about 24 hours to process 70,000 emails from it SPOOL out to the mail server. The machines is a dual 700 / 1/2 gig ram. I don't think its the machine but more the process of 70,000! emails. My initial thought is to group together 40 emails at a time and BCC then and have the sent to be whatever. That would bring the emails total down to about 1700 which CF can pump out fairly fast. Id prefer to stay in CF for this. Does anyone have any suggestions or things that they may have done. Thanks!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists