Subject | RE: [firebird-support] Oldest active <-> Next transaction |
---|---|
Author | Szakály Balázs |
Post date | 2004-04-26T09:13:44Z |
> One thing that is worth bearing in mind. Are you using any management tools at the same time?Just another thought.
> I get 'growth' if I leave IB_SQL looking at the table without refreshing it from time to time.
> It got left open on a site when the dial up connection crashed, and was causing trouble by the time the engineering got back in.
On my test app (which cause same problem) only two connection is to firebird. One the insert thread, and the second, which
periodically select from this test table. Before all select or insert i start new tansaction, and after SQL, always call commit.
No other connection.