Well, again thanks for all the help and tips guys and gal (and Will) ;-P I managed to cut the processing time of the send tool over half with some spring cleaning... or basically... rewriting it from the ground up to get rid of some seriously mentally challenged code ;-)
Stored procedures helped TREMENDOUSLY over normal cfquery tags. I dont normally cache queries in administrative tools but the ones that didnt get converted to stored procs got cached for 1 minute as well... that also cut off a small amount from the overall time. Caching the actual content of the page didnt seem to change anything really. But now that the entire tool is in AJAX... it gives the IMPRESSION of being basically instant :-) I can stop email bombing my co-workers now :-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 6:27 PM To: CF-Talk Subject: RE: mass emailing from CF Well that definitely SOUNDS good and even makes sense since the spool directory stays busy sending email after the page request has come and gone... but that is really all that is going on with that page when it times out.... hopefully the simple cache solves it. It definitely speeds it up to me. Thank everyone for their input and help. ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 1:23 PM To: CF-Talk Subject: Re: mass emailing from CF Bobby Hartsfield wrote: > > Just another side as to why I thought what I did about that Jochem, but if I > trigger the page locally... it takes about half a second to process. If I > remote into a computer off site and hit the page remotely (or have someone > else do it) it takes MUCH longer to process. > > When I did it locally, the page request was over like I said... about half a > second but the spool directory still had emails in it that gradually kept > disappearing as they sent. > > So if the there is that much of a difference just spooling the emails why > wouldn?t the user's speed matter and what is the cause of that huge > difference. I have no idea what causes the difference, but the speed of cfmail is not related to the speed of the client connection. Uploading a large file with e-mail addresses might make a difference, sending a few MB of data back to the client might make the difference, but it does not matter for cfmail. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
