Solved

Coldfusion 9 Server settings for Email Blasts

Posted on 2011-02-15
3
827 Views
Last Modified: 2012-05-11
I am using Coldfusion 9.01 Enterprise edition to send email blasts.  My DSN's are pointed to Microsoft Access Databases.  The table I am pulling from contains about 30k records.  When I pull from the Access DB the spool to disk is extremely slow and ( Ibelieve) times out and stops spooling records around the 7500th record.  Am I missing some setting to increase the buffering of records (spooling the emails to disk)?  The record pull is SLOOWWWW.

Thanks -
cf91.jpg
cf92.jpg
cf93.jpg
0
Comment
Question by:mmmcdee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:mmmcdee
ID: 34901695
I know this is a general question I posted above...  to add/append additional information:  Should I use Microsoft Access DSN or Microsoft Access with Unicode?  Are there settings in the advanced setting of the DSN setup that I should change to correct the slowness of the spooling of the emails?
0
 
LVL 16

Accepted Solution

by:
duncancumming earned 500 total points
ID: 34904231
I'm not sure if there isn't some confusion here - there are two parts to what you're doing.
1. Query an Access DB to get a list of email addresses
2. Send out the emails

Either part could be causing the slowness here.  So for instance, if you removed the email part and just did the query, does that page perform in a good time, or is it still just as slow?  

If it's still slow, the database is the problem.  In which case look at either rewriting your query, or perhaps using an Enterprise-level database (SQL Server, MySQL, Oracle, etc) instead of Access.

Alternatively if the query itself seems fine, then it's the email part that's slow.  And discussion about the database would therefore be mostly irrelevant.

You might want to provide us with some code for how you're doing the queries and sending the emails, to see if there's any little performance tweaks that could be made there.

You could also consider doing the mailshot in batches of say 5000 (there are ways to do this programmatically), but only as a last resort if the other ideas don't work.
0
 

Author Closing Comment

by:mmmcdee
ID: 35037990
I am limited to using Access as my DB of choice due to the limitations from the provider.  I called Adobe and they made changes in the XML config file to allow a longer timeout for all emails to be spooled to the drive. I hope I will be able to move the third party DB to a more robust solution in the future.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question