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 &amp; 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&nbsp;<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&nbsp;<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&nbsp;<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.&nbsp;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,&nbsp;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]
==^=======================================================


Reply via email to