CFMail - performance issue

[Thunderbirds]

Hi, I have developed a discussion board on which users can subscribe to
particular topics. Subscribed users receive an email (with link back to topic)
each time some user contributes to a particular topic they are subscribed to.
When users post a response to a topic I call an action page that does a number
of things. It inserts a new record into a table that stores all the topics and
responses. Then it runs a simple query that looks at a table called
'subscriptions'. I use a CFMAIL tag to send an email to all users who have
subscribed to this particular topic. My concern is that if, lets say 1000
people subscribed to the same topic then this could slow down the processing of
a users response to a particular topic. In other words a user decides to
respond to a topic but the processing of this response could be really slow if
I have to send an email to 1000 people from my action page. Is there are way
around this? Does this all make sense? Thanks in advance!

[Bill Sahlas]

What have your tests shown? Messages get spooled or queued and are
processes asyncronously. The actual mail send is a process that checks a
folder on your server for message files and if it finds them then the files
or messages are sent. That is separate from a POST action of a form. Are
you finding that there is a bottle neck at the cfmail tag?

"Thunderbirds" <webforumsuser@macromedia.com> wrote in message
news:cv2j90$jae$1@forums.macromedia.com...

> Hi, I have developed a discussion board on which users can subscribe to
> particular topics. Subscribed users receive an email (with link back to
> topic)
> each time some user contributes to a particular topic they are subscribed
> to.
> When users post a response to a topic I call an action page that does a
> number
> of things. It inserts a new record into a table that stores all the topics
> and
> responses. Then it runs a simple query that looks at a table called
> 'subscriptions'. I use a CFMAIL tag to send an email to all users who have
> subscribed to this particular topic. My concern is that if, lets say
> 1000
> people subscribed to the same topic then this could slow down the
> processing of
> a users response to a particular topic. In other words a user decides to
> respond to a topic but the processing of this response could be really
> slow if
> I have to send an email to 1000 people from my action page. Is there are
> way
> around this? Does this all make sense? Thanks in advance!
>

[Thunderbirds]

My database is small at present and so I am not having any performance
problems. I am however presuming that I will have problems when I have more and
more email addresses in my DB. I want users to be able to submit replies to
threads on the discussion board quickly. However the action page that inserts
the reply also checks for subscriptions to this particular topic and then sends
emails to all those who have subscribed. Because this code is on the same page
that inserts the reply data I am concerned that users will have to wait for the
page to process as CFMAIL loops through the query as follows: <cfmail
query='GetSubscriptions' TYPE='HTML' SERVER='195.218.875.75' to='#email#'
from='someemailaddress.com' subject='Message from Forum'> <a
href='http://.....>some link</a> </cfmail> Hope this makes sense? Thanks!