----- Original Message -----
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Friday, July 26, 2002 5:37 PM
Subject: [iMS] recording recipients on send
> Hello,
>
> Lets say I have 25,000 recipients returned from a query and I start to loop
> over the cfx_imsmail tag. Does it make sense to build a new query and add
> each recipient one by one to this new query object?
>
> Then, after the loop I can use this query to write the to the database the
> complete list of recipients.
>
The cfx tag can take all the recipients from the query - no need to loop over the tag
(use query and queryfield
parameters).
> I could wrap this in a cftry/catch block, where the catch block records the
> successful deliveries (from the query I was building row by row) and then
> reschedules the rest or something like that.
>
> Does this make sense as a way to track which recipients had actually been
> sent to the que? Is this going to create to much additional overhead?
>
The cfx tag will throw an exception if there is a problem writing to the queue. So,
you can trap on that. In all the
years we've been using the cfx and supporting others that use it I have only seen or
heard of write errors when the
queue disk is full.
> Also, I am calling the imsmail tag within a query output like this:
>
> <cfoutput query="rcp">
> <cfsavecontent variable="emailbody">
> <cfinclude template="dynamicallygeneratedemailbody.cfm">
> </cfsavecontent>
>
> <!--- send mail to single recipient using the emailbody built above --->
> <cinclude template="act_sendmail.cfm">
> </cfoutput>
>
> Am I asking for trouble on large(25,000-50,000) mailing campaigns like this?
>
The differences between using one call of the cfx and looping over it are that the
looping is slower and the looping
will utilize more space on the disk and a bigger overall queue.
Regards,
Howie
> Brook Davies
>
>
>
>
==^=======================================================
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]
==^=======================================================
