On Thu, Feb 23, 2006 at 05:39:17PM +0800, ekcien wrote: > You are right, i am using Access as my database and server activities are > growing too busy. > It is time for me to migrate to MS SQL. > Thanks for your advice. > > Rgrd > Ang
Ang, In the mean time, you might want to consult this Macromedia technote: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17034 which gives some tips about using MS Access in a production environment. Specifically, it recommends: # In ColdFusion Administrator, modify every Access ODBC Data source and set the following (you will need to click the CF Settings button to see these): * Buffer Size = 0 (ODBC only) * Page Timeout = 600 (ODBC only) * Uncheck Maintain Database Connections But do migrate to MS SQL or MySQL! Best, Charles ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
