RE: [firebird-support] Restoring Backup

Dimitry, > > When it is restoring data, it > > fills a data page and goes on to the next one. A large cache will > > fill with pages that will not be referenced again until the indexes > > are built. To build indexes, Firebird reads records and sorts by > > keys. That might suggest that

Re: [firebird-support] firebird and transaction behaviour questions

Hi, one select do not guarantee consistency if you run something outside of transaction context. And because of this, in Firebird there is no possibility to do this. consider folowing example select * from header h inner join detail d on d.id_h=h.id server do loop throught streams and: 1. it

Re: [firebird-support] Restoring Backup

24.02.2016 21:30, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > I am not sure that is the best way Yes, gfix is better. At least faster. -- WBR, SD.

Re: [firebird-support] Restoring Backup

Hello Ann. Thank you very much. The two hundred pages are not intended to be used for backup or restore purposes. In fact, I use the switche '-BU 20', in gbak -REP -c, to set the database cache pages option. This way I don´t need change the DefaultDbCachePages switche in the

Re: [firebird-support] Restoring Backup

24.02.2016 20:37, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > When it is restoring data, it > fills a data page and goes on to the next one. A large cache will fill with > pages that will not be referenced again until the indexes are built. To > build indexes, Firebird reads

Re: [firebird-support] Restoring Backup

On Wed, Feb 24, 2016 at 12:01 PM, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Referring to the buffers requested for gbak: > > > Why 12? Why not? :) > There's a cost to managing a large buffer cache. Firebird will use the entire cache even if

Re: [firebird-support] Restoring Backup

Hello HB. It happens with 2.5.5 32 bit. I believe that the limitation is beacuse 20 x 16384 (page size) = 3GB greater than the avaliable amount of memory or greater than the 32bit engine is capable to manage. I am not sure. Why 12? Why not? :) Hugo Em 24/02/2016 00:09, Helen

Re: [firebird-support] database formats?

On 24 Feb 2016 06:29:20 -0800, "heineferre...@yahoo.com [firebird-support]" wrote: > Hi, > > Is there any difference between the database format of a 32bit Firebird > database vs a 64bit Firebird database? Depends on the Firebird version. I believe in 2.0 or

RE: [firebird-support] database formats?

You can certainly backup and restore between Windows & Linux version and 32bit & 64bit version so long as you keep an eye on the version numbers and that you are using the same or a newer version where you are restoring it. Cheers, Neil Pickles – n...@csy.co.uk From:

[firebird-support] database formats?

Hi, Is there any difference between the database format of a 32bit Firebird database vs a 64bit Firebird database? Is there any difference between a database format running on a windows server vs one on a linux or mac server? In other words: Can you backup and restore between different 32/64