RE: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Wed, 8 Jul 2015 12:14:13 +, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Take a look here: http://www.firebirdfaq.org/faq361/ I'd add that restore also has a -use_all_space option. If you don't specify this, then

RE: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Take a look here: http://www.firebirdfaq.org/faq361/ I'd add that restore also has a -use_all_space option. If you don't specify this, then pages are filled to approximately 80% (80% is preferable over 100% unless it is a read-only database). See

[firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
Hi, Just for my cursiosity and for a better understanding of Firebird: what can be a possible reason for a gbaked and restored (to a different file) database being _larger_ than the original one? I've got a db of size 104521728 bytes. I do gbak -B -T database.fdb database.gbk, then gbak -C

Re: [firebird-support] Re: Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
W dniu 2015-07-08 o 14:50, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: 08.07.2015 15:18, Mark Rotteveel wrote: Another reason could be restoring with a different page size than the original database. Or some tables were altered to a longer record format after

[firebird-support] Re: Gbaked and restored database larger than the original?

2015-07-08 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
08.07.2015 15:18, Mark Rotteveel wrote: Another reason could be restoring with a different page size than the original database. Or some tables were altered to a longer record format after filling them with data. The original database contains records in the old (shorter) format while the

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
W dniu 2015-07-08 o 14:18, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: Another reason could be restoring with a different page size than the original database. Both databases have 8k pages. Tomasz -- __--==--__ __--== Tomasz Tyrakowski

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 2015-07-08 o 14:14, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: Take a look here: http://www.firebirdfaq.org/faq361/ Yes, I've come across this on another occasion, but it doesn't seem to apply to my case (I didn't switch to a different version of

[firebird-support] Re: Problem occuers while trying to generate trace file

2015-07-08 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, babak_bsn@... wrote : I would like to trace data base activity in fire bird using Audit/Trace Services. I run this command in my command prompt: C:\Program Files\Firebird\Firebird_2_5\binfbtracemgr -se localhost/3050:service_mgr -user SYSDBA

Re: [firebird-support] Re: Problem occuers while trying to generate trace file

2015-07-08 Thread Babak Bastan babak...@gmail.com [firebird-support]
Thank you Vlad, it works now On Wed, Jul 8, 2015 at 11:36 AM, hv...@users.sourceforge.net [firebird-support] firebird-support@yahoogroups.com wrote: ---In firebird-support@yahoogroups.com, babak_bsn@... wrote : I would like to trace data base activity in fire bird using Audit/Trace

[firebird-support] FB_INET_SERVER.EXE using all the memory

2015-07-08 Thread mauricio.m...@yahoo.com [firebird-support]
Hello! I have two databases in my Firebird 2.5.3 The first is of 7.5GB and second is of 2.0GB My server has 4GB of Memory, and sometimes the service FB_INET_SERVER.EXE starts eating my memory from 1.5GB to 2.5GB-3GB of memory and my system slows down.. Same concurrent users, what

Re: AW: [firebird-support] Changing Columns

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 7, 2015, at 2:25 AM, 'checkmail' check_m...@satron.de [firebird-support] firebird-support@yahoogroups.com wrote: .. or is there an option to export all data from the database without database itself, then I can change the ddl, create a clean database and import the data again? If

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 8, 2015, at 8:14 AM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Take a look here: http://www.firebirdfaq.org/faq361/ I'd add that restore also has a -use_all_space option. If you don't specify this,