HI all,
[EMAIL PROTECTED] said :
> What is the difference in
> efficiency vis-a-vis looping x times and making x cfx_imsmail calls ?
Howie said :
> In my opinion, calling the cfx tag once is better than looping
> over cfmail calls.
Why not test both? Monitor the CPUs / Disks / Memory /CF usages and make
your choice.
[EMAIL PROTECTED] said :
> x may be in the range of 5000 - 10000
> at present, and will rise with time.
Try it with several size datasets from 10000 - 100000 , and see what
happens.
> 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
You chould use query of query functionality in cf5 or do more work in the
SQL.
I would imagine the biggest hit will be in the processing of the 6 cfquerys.
Try to reduce this load , use stored procs if possible.
Temp SQL tables or view might help too.
Justin
==^=======================================================
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]
==^=======================================================
