?
Solved

Coldfusion 9 Server settings for Email Blasts

Posted on 2011-02-15
3
Medium Priority
?
833 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
  • 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 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
Integration Management Part 2
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Suggested Courses

621 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