Solved

Coldfusion 9 Server settings for Email Blasts

Posted on 2011-02-15
3
822 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now