| Subject | Re: [firebird-support] Understanding Sweep |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-10-24T02:56:17Z |
At 12:10 PM 24/10/2007, you wrote:
Your gstat figures are consistent with an app that starts lots of transactions automatically, that never get committed. AFAIK, dbXpress (like other Delphi connectivity component suites) will start a transaction if one is not started but won't take care of committing any transaction.
Firebird itself will eventually commit transactions left hanging from lost connections but, going by info you have provided so far, your SQLConnection is not being abandoned, just neglected...(just guessing....)
./heLen
>Helen,Read the help for TSQLConnection? (StartTransaction and Commit methods, et al.) Read the (copious) documentation in the Delphi manual for DBX which does seem to be somewhat pitched at MySQL (which doesn't have transactions, natch!)
>
>I've never heard about controlling transactions manually when
>populating a ClientDataset. I have no idea how to do it. :) dbExpress
>always handled this for me.
>
>What should I do?
Your gstat figures are consistent with an app that starts lots of transactions automatically, that never get committed. AFAIK, dbXpress (like other Delphi connectivity component suites) will start a transaction if one is not started but won't take care of committing any transaction.
Firebird itself will eventually commit transactions left hanging from lost connections but, going by info you have provided so far, your SQLConnection is not being abandoned, just neglected...(just guessing....)
./heLen