Helen Borrie wrote:

>At 02:02 PM 4/02/2004 +1300, you wrote:
>
>
>>Helen Borrie wrote:
>>
>>
>>
>>>At 09:52 AM 4/02/2004 +1300, you wrote:
>>>
>>>
>>>
>>>
>>>>My app freezes after running for few hours. I have upgraded to FB1.5 and
>>>>still have this problem. The app freezes but FB can be used. Is there
>>>>something in IBO that needs to be done regularly to avoid this. The
>>>>transaction difference between OAT and Next is between 1 and 100.
>>>>
>>>>
>>>>
>>>>
>>>Sandeep, if there are 99 transactions running with Autocommit then you are
>>>getting no garbage collection. The higher the pile of garbage, the harder
>>>it gets to reach the door. Eventually, the door just won't open.
>>>
>>>There is not enough information here to come to any finer-grained
>>>
>>>
>>conclusion.
>>
>>
>>>
>>>
>>The transaction difference of 100 is for a short duration (10-20 secs)
>>when the app is processing records. After that it is ok. And that is the
>>only thing this app does.
>>
>>
>
>One "run" of this process starts 100 transactions? What is it doing (both
>sides of the wire)?
>

There are few tables that are updated, and most of the stuff is done
using Stor Procs.

Regards

Sandeep