I think im going to have trouble with CF querying 1 million records 
before I even get a chance to send the mail.

jeff

-----Original Message-----
From: "ims" <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Date: Fri, 12 Jul 2002 08:12:15 +0100
Subject: Re: [iMS] Large query to CFX_imsmail

> Thanks for the soothing words :)
> 
> Im thinkin I should try sending 1 million to a different mail server of
> ours as a test.
> 
> j
> 
> -----Original Message-----
> From: "Howie Hamlin" <[EMAIL PROTECTED]>
> To: inFusion Support List <[EMAIL PROTECTED]>
> Date: Fri, 12 Jul 2002 11:05:19 -0400
> Subject: Re: [iMS] Large query to CFX_imsmail
> 
> > This should not be a problem as long as the machine has a decent
> amount
> > of RAM (the cfx will actually build a sorted
> > list of all 1 million email addresses in memory).   Although we don't
> > send out more than 3000 or so emails at one time I
> > think that some of our other clients are sending out this many.
> > 
> > Also, iMS 2.5 (which should be released in a few weeks) has a new
> > storage scheme for outgoing mail which should increase
> > the efficiency of sending out large quantities of mail.
> > 
> > Regards,
> > 
> > Howie
> > 
> > ----- Original Message -----
> > From: "ims" <[EMAIL PROTECTED]>
> > To: "inFusion Support List" <[EMAIL PROTECTED]>
> > Sent: Friday, July 12, 2002 2:54 AM
> > Subject: [iMS] Large query to CFX_imsmail
> > 
> > 
> > > I thought I would get some feedback to this thought :)
> > >
> > > I plan on using ims to send out about 1 million emails with
> qtokens. 
> > Is
> > > it just as easy as querying all 1 million emails (MS SQL7.0) and
> > passing
> > > the query to the cfx_imsmail tag with in a cfm template?  Ive done
> > this
> > > with smaller queries, is there any reason why I shouldnt do this
> with
> > a
> > > query of 1 million rows?
> > >
> > > Thanks,
> > > Jeff
> > >
> > >
==^=======================================================
     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