In my opinion, calling the cfx tag once is better than looping over cfmail calls. The
only potential problem that I see is that you are using multiple queries for creating
and delivering the email. The cfx tag can use only one query. With multiple queries
you would need to loop over the cfx tag or create new columns in the first query
(QueryAddColumn) and then fill in the other columns from the other queries. Then, you
can pass this new query to the cfx.
Regards,
Howie
----- Original Message -----
From: "John Innit" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 7:55 AM
Subject: [iMS] One CFX_IMSMAIL call vs. multiple - difference in efficiency ?
> Howie,
>
> We are presently running an alert schedule that runs on a daily basis. The
> structure is as follows :
>
>
> <cfquery name="outer"----------------------------------->
> <!--- This gets the list of recipients --->
>
> <cfoutput query="outer">
> <!--- Now loop through all recipients --->
>
> <cfquery name="first" ----->
> <!--- Get first list of items to send for the particular candidate--->
> </cfquery>
>
> <cfquery name="second" ----->
> <!--- Get second list of items to send for the particular candidate--->
> </cfquery>
>
> <!--- Now do some string manipulation to merge the two lists--->
>
> <cfquery name="getdetails">
> <!--- Get details pertaining to list of items for this candidate--->
> </cfquery>
>
> <cfloop query="getdetails">
> <!--- Create body of mail with details of items--->
> </cfloop>
>
> <cfmail -----> <!--- To send out mail to specific candidate--->
>
> </cfoutput>
>
> </cfquery>
>
>
> This structure forces me to call cfmail x number of times, where x is no of
> recipients. Now if I am going to replace cfmail declarations with
> cfx_imsmail, I would like to take advantage of the query feature.
>
> Would you recommend that I redesign this schedule so that it can use one
> single cfx_imsmail declaration with a query ? What is the difference in
> efficiency vis-a-vis looping x times and making x cfx_imsmail calls ? x may
> be in the range of 5000 - 10000 at present, and will rise with time.
>
> Hope you can shed some light on this.
>
> Thanks.
>
==^=======================================================
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]
==^=======================================================
