Helen Borrie wrote:

>At 02:57 PM 4/02/2004 +1300, you wrote:
>
>
>
>>>>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.
>>
>>
>
>Sandeep, if the cause of your problem is a single process that needs 100
>concurrent transactions (which is pretty abnormal) then how do suppose this
>"problem description" is going to help find the source of your
>problem? You are reporting something that shouldn't occur. If you
>seriously want to find and fix the problem, you will make the effort to
>describe the conditions where it occurs. If you don't, I fail to see the
>point of starting a support thread on the topic in two lists.
>

I have gone thru the app again and managed to get the Next Transaction
number difference, after one process run, down to 23 i.e. the process
now uses 23 Transactions.
Process is not the right word, it is actually Delphi Application
procedure which executes few database stor procs.

Regards

Sandeep