I use dbExpress driver to firebird. Simple StartTransaction, Select, Insert..., Commit.

I not use any management tool. Only midingth run by scheduler the sweep, but no affects.


---------------------
Szakály Balázs
szoftver fejlesztő
szakalyb@...
www.microraab.hu
+36(30)9363639
+36(96)510738


-----Original Message-----
From: Lester Caine [mailto:lester@...]
Sent: Sunday, April 25, 2004 8:45 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Oldest active <-> Next transaction

Szakaly Balazs wrote:

> My question: how i create app, where a thread insert rows to a table,
> and another read from this. As i see, in this case the OAT never change (except if i restart my app).
>
> I not use commitretain.

You will have to remind us what tools you are using.

I had major problems with BDE and the early Borland replacement, but having switched to IBO, I've never seen the problem again (
Alright I have but I did a silly and left an edit open ;) )

One thing that is worth bearing in mind. Are you using any management tools at the same time? 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. Just another thought.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services




Yahoo! Groups Links