Hi Zac We do that. One DB user has full permissions for all the relevant DBs on the server. When a user logs in and selects a DB, we store the DB data in session and then pass the DB name and DB user to the queries.
On Apr 28, 1:12 pm, "Zac Spitzer" <[EMAIL PROTECTED]> wrote: > You can always create a db user which has access to multiple db's on > the same db server > and control access via CF and then specify the database in the SQL > which would make > things a lot easier to manage and would vastly reduce the number of > connections > required to the database server > > > > On Mon, Apr 28, 2008 at 1:00 PM, Nathan Drury <[EMAIL PROTECTED]> wrote: > > > Hi Andrew > > > Our application is used by law firms to manage documents that form > > part of a litigation matter. The one single application can be used > > to support several litigation matters at a given time, with each > > litigation matter having its own DB. While a user can only ever be > > working on one matter at a time, there can be multiple users working > > on different matters at a given time, hence the one application > > accessing multiple DBs. We also host the application for law firms > > and have a lot more than 20 matters, but not all matters are being > > accessed all the time so I just said 20. > > > Cheers > > > Nathan > > > On Apr 28, 12:17 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > 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: [email protected] [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&sl... > > > > ). > > > > Can anyone shed some light on when NOT to maintain connections? > > > > Thanks > > > > Nathan > > -- > Zac Spitzer -http://zacster.blogspot.com(My Blog) > +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
