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]
==^=======================================================
