Post reply

Auto Close Database Option

  • October 10, 2003 at 5:01 am

    #84614

    Hello,

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

    Thanks

    J

  • October 10, 2003 at 7:24 am

    #477844

    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.

  • October 13, 2003 at 2:36 am

    #477972

    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