Subject | Re: Firebird speed degrades during the day |
---|---|
Author | peter_65@rocketmail.com |
Post date | 2013-02-06T17:43:43Z |
--- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote:
>Thanks Sean, Obvious when you put it like that, it shouldn't cause any issues then.
>
> > Thanks Svein, I will re-check all the transactions but am careful to start and
> > commit transactions. This isn't a general problem with the program, it seems
> > to be isolated to this user. Something you said did strike a chord though. This
> > user does tend to have users that use terminal server to access the system.
> > If they are not logging out of TS could this be a potential cause?
>
> Depends on several things.
>
> If a user walks away from their PC with your application running, how likely is it that your application would have an open db transaction?
>
> Closing a TS sessions (ie. not logging out) is like walking away from the PC.
>
>
> Is the TS setup to logoff/kill idle sessions?
>
> If not, applications will continue to run without end. The next time to user connects to TS, they will pick up the previous session.
>
>
> Sean
>