Request time out issue with Cfmail

Forum|Forum|16 years ago
March 1, 2010
1 reply
1293 views

Hi All,

Am using event gateway for sent newsletter email. When I sent large amount of newsletter letters cf mail tag time out occurred.

My mail sent process as follows

Step 1 :

cfloop(query)

{

cfquery for insert recipient to table

}

Step 2:

cfloop(query)

{

cfmail for send mail

cfquery for update table

}

Today I have tried to send 7000 newsletter, I got time out issue in Step 2 cfmail. I have noticed that the insert process in the Spet 1 takes upto 7 minutes for completing(inserting 7000 records).

Am in using MySQL 5 and CF8

This topic has been closed for replies.

D

Dan_Bracuk

Inspiring

Step 1 seems odd. Looping through a query implies that you already have the recipient data stored somewhere. Why are you inserting it somewhere else?

Also, what are you updating in Step 2?

Dileep_NRAuthor

Inspiring

In Step1:

Recipient list will be queried from a search criteria by the user. This result will be inserted into a table with mail sent flag is FALSE.

In Step 2:

Send mail to each recipient and set that receipt mail sent flag to TRUE

D

Dan_Bracuk

Inspiring

Seems kind of odd, but it's your data. In any event, you don't need a loop. Whatever logic you used to select the recipients can also be used for your insert and update queries.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded