The machine we are using has an AMD single 1.3 GHZ processor, 512 MB Ram (2 x 256 DDR 266MHz 184-pin), 20 Gig. Maxtor 5400 rpm HD. Connected to 10 meg. port on a frame t-1 (upload about 800 to 900 kbs).
When we tried sending the mails all it once, Studio timed out in the query. One big problem after this is how to handle the out and queued directories. Openning with the Explorer causes the machine to lock up. We fond that the only way to get at the files is with the dos command prompt. Code follows: <cfparam name="url.start" default="1000000"> <cfset sendThisMany = 100000> <cfset endHere = start + sendThisMany> <cfquery name="email" datasource="Database" username="user" password="password" dbtype="ODBC"> select email, fName, optinID as email_id from newData1M where id > #url.start# and id < #endHere# </cfquery> <cfx_imsmail query="email" queryfield="email" qtoken_Name="fName" qtoken_id="email_id" qtoken_mailCampID="mailCampID" header_from="""Valentines Day Patrol"" <[EMAIL PROTECTED]>" header_tracking="quality code: <:id:>." header_to = "<:smtpto:>" header_Reply_To="[EMAIL PROTECTED]" parsetokens="yes" header_subject="A Dozen roses .. 39.99 with free Ghirardelli chocolates !" smtpfrom="[EMAIL PROTECTED]" MAXRECIPIENTS="9" failto="null" warnto="null" html="<!-- saved from url=(0022)http://internet.e-mail --> <HTML> <HEAD> <TITLE>Dozen Roses & FREE Chocolates ONLY $39.99!</TITLE> <STYLE></STYLE> </HEAD> <BODY text=##000000 vLink=##006600 aLink=##006600 link=##006600 bgColor=##ffffff topMargin=8 centerMargin=""8"" marginheight=""8"" marginwidth=""8""> <DIV> <table width=""100%"" align=center cellpadding=""0"" cellspacing=""0"" border=""0"" bordercolor=""000000""> <tbody> <tr> <td align=middle> <div align=""center""><font face=Verdana><font size=1>The following message was sent to you as an opt-in subscriber to <span class=680023821-24012002>one of </span><span class=220294620-24012002>Broad Vision Media's website<span class=680023821-24012002>s</span>, or one of our <span class=680023821-24012002>marketing </span>partners<span class=680023821-24012002>.</span></span><span class=700032621-24012002> </span>We will continue to bring you valuable offers on the products and services that interest you most. If you wish to unsubscribe please <span class=700032621-24012002>scroll to the bottom of this email or <a href=""##bottom""> click here</a>.</span></font></font> </div> </td> </tr> </tbody> </table> <FONT face=Verdana,Arial,Helvetica color=##cc0000 size=+1><B><br> </B></FONT></DIV> <FONT face=Verdana,Arial,Helvetica color=##cc0000 size=+1><B> <CENTER> Valentine's Day is February 14th! </CENTER> </B></FONT> <DIV></DIV><BR> <TABLE cellSpacing=0 cellPadding=0 width=610 align=center border=0> <TBODY> <TR> <TD vAlign=top align=left width=10 height=12></TD> <TD align=middle width=""99%"" ></TD> <TD vAlign=top align=right width=10></TD></TR> <TR> <TD width=10></TD> <TD vAlign=top width=""99%"" height=840> <TABLE cellSpacing=0 cellPadding=8 width=""100%"" align=center bgColor=##ffffff border=""1"" bordercolor=""CC0000""> <TBODY> <TR> <TD vAlign=top align=middle width=""100%""> <TABLE cellSpacing=0 cellPadding=0 width=""100%"" border=0> <TBODY> <TR> <TD vAlign=center align=middle width=80><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=56 src=""http://www.getfreepizza.com/email/images/proflowers_logo.gif"" width=72 border=0 NOSEND=""1""></A> </TD> <TD vAlign=center align=middle> <div align=""center""><font face=""Verdana,Arial,Helvetica"" size=""5""><:Name:> - Time is running out!</font></div> </TD> </TR></TBODY></TABLE> <P align=""center""><FONT face=Verdana,Arial,Helvetica size=3><B><FONT color=##cc0000>Valentine's Day is February 14th</FONT></B>, and we've partnered with Proflowers.com to make this day extra special. </FONT> <P> <TABLE cellSpacing=0 cellPadding=2 align=center border=0> <TBODY> <TR> <TD vAlign=center align=middle colSpan=2> <TABLE cellSpacing=0 cellPadding=0 align=center table border=0> <TBODY> <TR> <TD vAlign=center align=middle width=70><IMG height=57 alt="""" src=""http://www.getfreepizza.com/email/images/CHT_tn.gif"" width=55 border=0 NOSEND=""1""> </TD> <TD vAlign=center align=middle> <div align=""center""><FONT face=Verdana,Arial,Helvetica color=##cc0000 size=3><B>Proflowers will include a <A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><FONT face=Verdana,Arial,Helvetica color=##cc0000 size=3>FREE BOX OF FAMOUS GHIRARDELLI CHOCOLATES</FONT></A> in a velvet heart shaped box with any magnificent flowers you send!</B> </FONT></div> </TD></TR></TBODY></TABLE></TD></TR> <TR> <TD vAlign=center align=middle colSpan=2> <HR color=##cc0000 noShade SIZE=1> </TD></TR> <TR> <TD vAlign=center align=middle rowSpan=3><FONT face=Verdana,Arial,Helvetica color=##990099 size=+2><B>Beautiful One Dozen Long Stemmed Sweetheart Roses</B> </FONT><BR><FONT face=Verdana,Arial,Helvetica color=##cc0000 size=+2><B>ONLY 39.99!</B> </FONT><FONT face=Verdana,Arial,Helvetica size=1>plus delivery </FONT><BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=391 src=""http://www.getfreepizza.com/email/images/SweetheartRoses.jpg"" width=372 vspace=3 border=0 NOSEND=""1""></A> <BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=19 src=""http://www.getfreepizza.com/email/images/t_ordernow.gif"" width=117 border=0 NOSEND=""1""></A> <BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=16 src=""http://www.getfreepizza.com/email/images/t_details4OrderNow.gif"" width=117 border=0 NOSEND=""1""></A> </TD> <TD vAlign=bottom align=middle width=200 height=""50%""><FONT face=Verdana,Arial,Helvetica color=##990099 size=-1><B>Fabulous One Dozen<BR>Long Stemmed<BR>Red Roses</B> </FONT><BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=143 alt="""" src=""http://www.getfreepizza.com/email/images/RedRoses2_tn.jpg"" width=163 border=0 NOSEND=""1""></A> <BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=19 src=""http://www.getfreepizza.com/email/images/t_ordernow.gif"" width=117 border=0 NOSEND=""1""> <BR> <IMG height=16 src=""http://www.getfreepizza.com/email/images/t_details4OrderNow.gif"" width=117 border=0 NOSEND=""1""></A> </TD> </TR> <TR> <TD> <HR color=##cc0000 noShade SIZE=1> </TD></TR> <TR> <TD vAlign=top align=middle width=200 height=""50%""><FONT face=Verdana,Arial,Helvetica color=##990099 size=-1><B>20 Amazing<BR>Sweetheart Tulips</B> </FONT><BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=143 src=""http://www.getfreepizza.com/email/images/SVFswthrttulips_tn.jpg"" width=163 vspace=3 border=0 NOSEND=""1""></A> <BR><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><IMG height=19 src=""http://www.getfreepizza.com/email/images/t_ordernow.gif"" width=117 border=0 NOSEND=""1""> <BR> <IMG height=16 src=""http://www.getfreepizza.com/email/images/t_details4OrderNow.gif"" width=117 border=0 NOSEND=""1""></A> </TD> </TR> <TR> <TD vAlign=center align=middle colSpan=2> <HR color=##cc0000 noShade SIZE=1> <div align=""center""><FONT face=Verdana,Arial,Helvetica size=-1><B>Send a beautiful bouquet of long-stemmed Sweetheart Roses for an astonishingly low $39.99</B> (plus shipping by FedEx), and <FONT color=##cc0000><B>we will include complimentary delicious Ghirardelli chocolate in a beautiful velvet heart shaped box.</B></FONT> </FONT> </div> <P align=""center""><FONT face=Verdana,Arial,Helvetica size=-1>Proflowers' unique ""Direct from the grower"" system gives you twice the freshness at half the price and lets you enjoy a seven-day freshness guarantee . You also get quick delivery when you've suddenly remembered you should have ordered flowers and automatic e-mail confirmations that tell you exactly when your flowers are shipped and exactly when they're delivered. </FONT> <P align=""center""><FONT face=Verdana,Arial,Helvetica color=##cc0000 size=+1>Quantities are limited so place your order for Valentine's Day delivery now. <B><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank>CLICK HERE TO ORDER!</A></B> </FONT> <P align=""center""><FONT face=Verdana,Arial,Helvetica size=-1>Check out our other unbelievable Valentine's Day values. You will get a box of free Ghirardelli chocolate with any flower order.</FONT> <P align=""center""><font face=""Verdana,Arial,Helvetica"" size=""-1""><:Name:> NOTHING says ""Happy Birthday,"" or ""I Love You,"" or ""Thank You,"" or ""I Miss You,"" or just ""I Care"" better than beautiful, fresh, lovely and deliciously fragrant flowers, especially gorgeous long-stemmed roses! </font> <P align=""center""><FONT face=Verdana,Arial,Helvetica size=-1><A href=""http://www.proflowers.com/jump/vday2002.cfm?REF=FCHBVGVDay09"" target=_blank><B>CLICK HERE TO ORDER!</B></A></FONT> </TD></TR></TBODY></TABLE> </TD> </TR></TBODY></TABLE></TD> <TD width=10></TD></TR> <TR> <TD vAlign=bottom align=middle width=10></TD> <TD align=middle width=""99%"" background=http://www.getfreepizza.com/email/images/bar_bottom.gif height=10></TD> <TD vAlign=bottom align=right width=10 background=http://www.getfreepizza.com/email/images/bar_right.gif height=12></TD></TR></TBODY></TABLE> <br> <table width=""710"" border=""0"" cellspacing=""2"" cellpadding=""2"" align=""center""> <tr> <td><font face=Arial size=2><font face=Arial size=2> <hr style=""WIDTH: 700px; HEIGHT: 4px"" align=center width=700 size=4> </font></font> <div align=""center""><font face=Arial size=1><span class=220294620-24012002>Click here <a href=""http://unsubscribe.bvmailer01.com?email=<:smtpto:>""> unsubscribe</a>, enter your email address, and click on the unsubscribe button.Or you can send a postcard to 6278 North Federal Highway, Suite 187 Ft. Lauderdale 33308. Only unsubscribe requests submitted to this page can be fulfilled<span class=630541021-24012002>. </span>The products and/or services advertised in this email are the sole responsibility of the advertiser, questions about this offer should be directed to the advertiser.<br> </span></font> <hr style=""WIDTH: 692px; HEIGHT: 4px"" align=center width=692 size=4> </div> </td> </tr> </table> <a name=bottom></a> <br> </BODY></HTML> " > Email Loaded !!! Master ----- Original Message ----- From: "Raven R. Cecil" <[EMAIL PROTECTED]> To: "inFusion Support List" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 2:29 PM Subject: RE: [iMS] Moving iMS > Did you have any problems with sending the mails all at once to the queue? I > would love to see the code if Jeff gives permission! > > > Raven > > > -----Original Message----- > > From: David A. Goldfield [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, February 14, 2002 1:30 PM > > To: inFusion Support List > > Subject: Re: [iMS] Moving iMS > > > > > > So far in our testing and deployment of IMS Post we have sent > > out as many as > > 1 million emails in a run. We found best performance, without > > spending 5k on > > hardware, by setting up scheduled templates in CF admin to query a sql > > database on the same machine to inject the out directory with > > 100k emails > > every two hours over a 10 period. The code was written by > > Jeff and would be > > happy to send it with his permission. > > > > Regards, > > Dave Goldfield > > BVG Integration > > > > > > ----- Original Message ----- > > From: "Raven R. Cecil" <[EMAIL PROTECTED]> > > To: "inFusion Support List" <[EMAIL PROTECTED]> > > Sent: Thursday, February 14, 2002 2:15 PM > > Subject: RE: [iMS] Moving iMS > > > > > > > > > > > > > > -----Original Message----- > > > > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, February 14, 2002 12:35 PM > > > > To: inFusion Support List > > > > Subject: Re: [iMS] Moving iMS > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Raven R. Cecil" <[EMAIL PROTECTED]> > > > > To: "inFusion Support List" <[EMAIL PROTECTED]> > > > > Sent: Thursday, February 14, 2002 1:24 PM > > > > Subject: [iMS] Moving iMS > > > > > > > > > > > > > Greetings, > > > > > > > > > > We would like to move iMS to a server separate from our CF > > > > server. Has > > > > > anyone done this, and how is it accomplished? > > > > > > > > > > > > > If you don't need reportpoststatus, or the failure/warning > > > > templates then you don't need cf at all. It's just a matter > > > > of loading > > > > the post server on the other box and writing mail files to > > > > the proper folder. > > > > > > > > > So, it is not possible if we need to use these templates? > > > > > > Here is our situation. > > > > > > We have a brand new Compaq Box with one PIII 900 & SCSI > > RAID 15000 RPM & > > > 512MB of RAM running CF IIS and IMS POST. The box cannot > > seem to keep up > > > with the amount of mailings we are sending, and it locks up > > when we send > > out > > > 200K+ (about 45% are bad addresses, but we cannot remove > > them at this > > time). > > > I tried finding the issue with PerfMon, and it shows huge > > spikes in POST > > > server activity. I tried anywhere from 15 down to 1 Sim. > > App. Serv. Conn. > > > and at the same time dropped the thread count. We still > > have not found the > > > cause, so we are looking to boost server specs or switch > > IMS to its own > > > server. > > > > > > Any ideas? > > > > > > > > > Raven > > > > > > > > > > > > > > > > > > > > <snipped> > > > ==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/iMSSupport.cfm Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/iMSDevelopers.cfm List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [email protected] ==^=======================================================
