> that "Maintain database connections" should be unchecked in a
> shared environment. Does anyone know what best practice is on
> this?
In general, you want to maintain database connections, because they're
expensive to create and destroy at runtime. However, there are some cases
where you might not want to do this:
- if your specific database environment (including drivers) doesn't work
well with it enabled,
- if you're using a file-based database like MS Access and you want to be
able to overwrite the file while CF is running
- if your application can't take advantage of them because it's using
user-specific database logins for each application user, and has very few
database interactions per user
On a slightly unrelated note, I'd like to point out that best practices are
not often monolithic. They tend to be fluid, and dependent on your
situation.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
