Hi,

At June 17, 2003, 14:26, DataCom - Diego Moreira da Rosa wrote:

> Hey,

>> if my application is running 24 hours at the background, does it
>> consider an open transaction ?

> I am having some related problems. My application is running 24h at the
> background and all the requests and inserts are atomic. However, the size of
> the database keeps growing indefinetely. Do you think it can be some problem
> with openned transactions?

Yes, one transaction that is still open can cause this. When you say
"atomic", do you mean that the transaction is opened then comitted for
each request and/or insert! One thing that you also have to remember,
that a select that is still open is keeping a transaction open.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)