Auto Close Database Option

  • Hello,

    Can anyone tell me the impact of not having the auto close option of a database set ?

    Thanks

    J

  • It will cause a lot of headaches. When all connections from the database end the DB closes and all it's info is flushed from the cache, when someone reconnects then the DB has to reopen. So you will take a large performance hit on databases that are open and closed alot and those that tend to stay open will not be as bad an issue but then why bother with those. Most folks agree do not turn that option on.

  • Thanks Antares

    J

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply