I usually suggest using the CFX with a query as opposed to looping over it. Using a
query is faster but i don't have
any benchmarks fot that.
I have also heard from other users that using pure CFML is also faster than the cfx
tag. I have some code that was
given to me and I could forward it to you if you want it.
Regards,
Howie
----- Original Message -----
From: "Mark W. Breneman" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 3:56 PM
Subject: [iMS] Loop list Vs query speed
> I have about 30K e-mails address that I retrieve from a database and then
> loop over currently the cfmail tag. I have seen the light and I am
> upgrading to IMS-se mail.
>
> Would it be quicker to loop over the cfx_iMSMail (many times) Vs using the
> query="test" queryfield="email" method. I am guessing that the query method
> would be faster. If so, how much?
>
> Why I build the loop is that I mark address as sent after the message are
> sent. So if my server would crash in the middle of a send I could restart
> the mail and not worry about sending duplicate messages out.
>
> Any thoughts?
>
>
>
> Mark W. Breneman
> -Macromedia Certified ColdFusion 5 Developer
> -Network / Web Server Administrator
> Vivid Media
> [EMAIL PROTECTED]
> www.vividmedia.com
> 608.270.9770
>
==^=======================================================
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]
==^=======================================================
