Link to home
Start Free TrialLog in
Avatar of mmmcdee
mmmcdeeFlag for United States of America

asked on

Coldfusion 9 Server settings for Email Blasts

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
Avatar of mmmcdee
mmmcdee
Flag of United States of America image

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of duncancumming
duncancumming
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mmmcdee

ASKER

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.