Solved

Coldfusion 9 Server settings for Email Blasts

Posted on 2011-02-15
3
823 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 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
cfchart display 12 97
Coldfusion - check if two values are within a range 4 52
cfspreadsheet 15 84
Coldfusion scheduled tasks as one task 2 79
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 …
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…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 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

19 Experts available now in Live!

Get 1:1 Help Now