So, during DB running time, there would not be same transaction ids ?
I thought, that to uniquely correctly identify current sql dependency we
have to use composite key : current_connection + current_transaction.
Adomas


Ryan Thomas wrote:

>No, there's a good example in the FB book, at 100 transactions per second it
>will take 1 year, 4 months, 11 days, 2 hours and about 30 minutes to roll
>over, plus backing up and restoring resets the TID!
>
>Cheers,
>
>Ryan Thomas
>TransActive Systems
>
>P: (02) 4322 3302
>F: (02) 4325 1141
>E: ryan@...
>W: http://www.transactive.com.au/
>
>
>
>
>>-----Original Message-----
>>From: firebird-support@yahoogroups.com
>>[mailto:firebird-support@yahoogroups.com] On Behalf Of kapsee
>>Sent: Thursday, 17 November 2005 8:16 AM
>>To: firebird-support@yahoogroups.com
>>Subject: [firebird-support] Transaction IDs
>>
>>Thanks. I kind of expected it to be larger than that. With 32 bits,
>>don't the numbers wrap not too infrequently ?
>>
>>Thanks!
>>
>>--- In firebird-support@yahoogroups.com, "Ryan Thomas"
>><ryan@t...> wrote:
>>
>>
>>>Hi Kapsee,
>>>
>>>From The Firebird Book:
>>>
>>>"Transaction IDs (TIDs) are 32-bit integers that are generated in a
>>>single-stepping series."
>>>
>>>If you don't already have this book then I suggest that you get it -
>>>
>>>
>>it's
>>
>>
>>>got pretty much everything that you need to know about
>>>
>>>
>>firebird in it.
>>
>>
>>>Cheers,
>>>
>>>Ryan Thomas
>>>TransActive Systems
>>>
>>>P: (02) 4322 3302
>>>F: (02) 4325 1141
>>>E: ryan@t...
>>>W: http://www.transactive.com.au/
>>>
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>From: firebird-support@yahoogroups.com
>>>>[mailto:firebird-support@yahoogroups.com] On Behalf Of kapsee
>>>>Sent: Thursday, 17 November 2005 7:12 AM
>>>>To: firebird-support@yahoogroups.com
>>>>Subject: [firebird-support] Re: Transaction Info
>>>>
>>>>Thanks for the information. What's the size of
>>>>
>>>>
>>CURRENT_TRANSACTION (in
>>
>>
>>>>bytes) ?
>>>>
>>>>Thanks!
>>>>
>>>>--- In firebird-support@yahoogroups.com, "Adam"
>>>>
>>>>
>><s3057043@y...> wrote:
>>
>>
>>>>>>A few questions regarding transactions:
>>>>>>
>>>>>>1. Is it possible to get the transaction number in a trigger ?
>>>>>>
>>>>>>
>>>>>With Firebird 1.5 or higher,
>>>>>
>>>>>CURRENT_TRANSACTION
>>>>>
>>>>>
>>>>>
>>>>>>2. Are the transaction numbers assigned in an increasing
>>>>>>
>>>>>>
>>>>sequence ?
>>>>
>>>>
>>>>>Yes and no. Yes they are assigned in increasing
>>>>>
>>>>>
>>sequences, but they
>>
>>
>>>>>reset to 0 if you restore, so if the next transaction is
>>>>>
>>>>>
>>>>100, and you
>>>>
>>>>
>>>>>back it up and restore it, it goes back to 1.
>>>>>
>>>>>
>>>>>
>>>>>>3. gstat gives information about the oldest
>>>>>>
>>>>>>
>>transaction and oldest
>>
>>
>>>>>>active. What is the difference between the two ? Is
>>>>>>
>>>>>>
>>it possible to
>>
>>
>>>>>>obtain this information using any firebird API ?
>>>>>>
>>>>>>
>>>>>>
>>>>>I forget this myself. The difference between the two is
>>>>>
>>>>>
>>bad if it is
>>
>>
>>>>>too large. Ideally, they should remain pretty close. If the
>>>>>
>>>>>
>>>>gap is too
>>>>
>>>>
>>>>>big, then old record versions will start clogging up the
>>>>>
>>>>>
>>>>database with
>>>>
>>>>
>>>>>garbage. The normal culprits are commit retaining and rollback
>>>>>retaining, which do not release the context and so do
>>>>>
>>>>>
>>not help the
>>
>>
>>>>>garbage collection.
>>>>>
>>>>>Some light reading ;)
>>>>>http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_expert4
>>>>>
>>>>>I don't know if it is possible through the API.
>>>>>
>>>>>Adam
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>------------------------ Yahoo! Groups Sponsor
>>>>--------------------~-->
>>>>Get fast access to your favorite Yahoo! Groups. Make Yahoo!
>>>>your home page
>>>>http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/67folB/TM
>>>>--------------------------------------------------------------
>>>>------~->
>>>>
>>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>>
>>>>Visit http://firebird.sourceforge.net and click the Resources item
>>>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>>>
>>>>Also search the knowledgebases at http://www.ibphoenix.com
>>>>
>>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>>
>>>>Yahoo! Groups Links
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>>
>>------------------------ Yahoo! Groups Sponsor
>>--------------------~-->
>>Get fast access to your favorite Yahoo! Groups. Make Yahoo!
>>your home page
>>http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/67folB/TM
>>--------------------------------------------------------------
>>------~->
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Visit http://firebird.sourceforge.net and click the Resources item
>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>>Also search the knowledgebases at http://www.ibphoenix.com
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>