Re: [Firebird-devel] Max transaction duration

[Marco M. <mm...@ly...>]

What about a paramter for the transaction? I mean, each transaction can 
optionally specify the maximum duration. But I think that could be done 
at "client side" too, with some properties in the connection compoents. 
And I think that's precisely what IBO (www.ibobjects.com) native 
components do:
from the help of TIB_Transaction.TimeoutProps ...
...
ForceClosed
This property determines the period in seconds IBO will wait before it 
forces a transaction to end, without regard for user activity.

PromptUser
This is the point in time that IBO will actually get intrusive about 
prompting the user to get on with their work and get the transaction closed.

PromptUserDuration
Period in seconds between IBO's prompts to the user to resolve the 
outstanding transaction.

PromptUserRetry
Amount of time in seconds that IBO waits before retrying prompting the 
user to resolve their transaction.
...

regards
Marco Menardi

Christian Pradelli wrote:
> Hi!
> 
> Dealing with my application to see that any transaction keeps open during a
> long time, I think, is not possible to put a parameter in the configuration
> file to set a Max transaction duration?.
> This would be important because may be I'm a good developer and I do the
> best client-server application, but if a user open an administration tool,
> put a table in edit mode and keep it open....
> With a feature like this we could guarantee the performance of Firebird
> separating it from bad software design.
> 
> I'm right?
> 
> best regards christian
> Christian
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:
> With Great Power, Comes Great Responsibility 
> Learn to use your power at OSDN's High Performance Computing Channel
> http://hpc.devchannel.org/
> _______________________________________________
> Firebird-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>