Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Coldfusion 9 Server settings for Email Blasts

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
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 …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

604 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