RE: [firebird-support] Transaction ID overflow

2018-05-01 Thread Brian Dunstan brian.duns...@health.telstra.com [firebird-support]
Thanks Mark. From: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> Sent: Tuesday, 1 May 2018 5:34 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Transaction ID overflow On 1-5-2018 09:19, Brian Dunstan brian.duns...@health.telst

Re: [firebird-support] Transaction ID overflow

2018-05-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 1-5-2018 09:19, Brian Dunstan brian.duns...@health.telstra.com [firebird-support] wrote: > Hi, > > We have a big customer here who processes large numbers of transactions into > a large database and plans to not backup and restore. They should plan for backups and tests restores. But if you

Re: [firebird-support] Transaction ID overflow

2018-05-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.05.2018 9:19, Brian Dunstan brian.duns...@health.telstra.com [firebird-support] wrote: > If we move to dialect 3, does the TID become 64 bits? It is 48 bits in Firebird 3. -- WBR, SD.

[firebird-support] Transaction ID overflow

2018-05-01 Thread Brian Dunstan brian.duns...@health.telstra.com [firebird-support]
Hi, We have a big customer here who processes large numbers of transactions into a large database and plans to not backup and restore. We are using Dialect 3. I think that means that the TID is 32 bits. I think that means they get 4,294,967,296 transactions before overflow - I'm assuming the