Nathan, Do you mind if I ask what sort of application it is, and why there would be 20 different DB's? Maybe because it is Monday morning, I don't see any reason for it.
Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nathan Drury Sent: Monday, 28 April 2008 11:20 AM To: cfaussie Subject: [cfaussie] To maintain DB connections or not ... that is the question Hi We have a CF app which can be using multiple DBs at any given time (e.g. user1 logs into DB1, user2 logs into DB2, etc). At any given time the application can be accessing up to 20 different DBs. I've been trying to determine whether we should be maintaining connections to these DBs or not. I've found very little information out there about it except that as a general rule you should maintain connections and that you should limit connections to be the number of maximum simultaneous requests (per CF8WACK2). However, a colleague claims to have had issues in the past with the app when maintain connections is turned on (but this may have been due to a known issue with CF6.1 - http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18980&sliceId=1 ). Can anyone shed some light on when NOT to maintain connections? Thanks Nathan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
