Re: [firebird-support] How much percentage of a database space is a table contents taking.

2015-11-26 Thread rgilland1...@gmail.com [firebird-support]
Thomas, I ran gstat and here is the result there is no USAGE% column: Kind Regards, Robert. Database "op.fdb" Database header page information: Flags 0 Checksum 12345 Generation 28661 Page size 8192 ODS version 11.2 Oldest transaction 25549 Oldest active 28643

Re: [firebird-support] How much percentage of a database space is a table contents taking.

2015-11-26 Thread rgilland1...@gmail.com [firebird-support]
Hi, this is an output from ibexpert, no usage% column here either: Kind Regards, Robert. Database "OP.FDB" Database header page information: Flags 0 Checksum12345 Generation 28674 Page size

Re: Re: [firebird-support] Replication SW experience

2015-11-26 Thread Sudheer Palaparambil sudheer....@gmail.com [firebird-support]
Hi, Please have a look at SymmetricDS (http://www.symmetricds.org/). I have been using it for the past 4 years with Firebird. Thanks and regards. Sudheer Palaparambil On Thu, Nov 26, 2015 at 9:05 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]

Re: [firebird-support] How much percentage of a database space is a table contents taking.

2015-11-26 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
Hi Robert, you need to click on the second tab of the results - Tables. The first tab - Text - does only show what you have here. TableName SizeUsage% CUSTOMER11,960,3200.295 PARAMFIL16,3840.000 POSTCODES3,903,012,86496.335

Re: [firebird-support] How much percentage of a database space is a table contents taking.

2015-11-26 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
rgilland1...@gmail.com [firebird-support] schrieb am 27.11.2015 00:24: > Hi, > > > this is an output from ibexpert, no usage% column here either: > > > Kind Regards, > > > Robert. > > > Database "OP.FDB" > Database header page information: > Flags 0 >

Re: [firebird-support] Replication SW experience

2015-11-26 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
Hi Slavek, there are a number of issues you need to resolve before making a decision. If network performance is an issue then replication is not the answer - unless you can send the changes back to head office 'out of hours'. This means the different databases will be out of sync for some

Re: [firebird-support] How much percentage of a database space is a table contents taking.

2015-11-26 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Hi Robert, you can do this easily with a tool such as IBExpert. Just run > Services / Database Statistics and this is the result: > > TableName SizeUsage% > CUSTOMER 11,960,320 0.295 > PARAMFIL 16,384 1 0.000 >

Re: [firebird-support] Replication SW experience

2015-11-26 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Try IBReplicator. Regards, Alexey Kovyazin IBSurgeon Hi all, we are preparing new project with bidirectional replication. Customer idea is to have master database in head quoter and slave databases on production plant (to solve network performance and availability issues). Witch

ODP: Re: [firebird-support] Replication SW experience

2015-11-26 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
hi, modification datetime is not enaugh to replication. think about 1. transaction started and modify data2. synchronization started and fetch data from last modifird datetime3. synchronization end4. transaction commit data from point 1 and store datetime before synch started5.

Re: ODP: Re: [firebird-support] Replication SW experience

2015-11-26 Thread Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
I know, what is better? It is same in normal client server. Two client start editing same record. Who will win? In paranoia system, you will use dummy update before edit starts. But in real, mainly web, system? Slavek Ing. Slavomir Skopalik Executive Head Elekt Labs s.r.o. Collection and

[firebird-support] Re: Firebird for a web application

2015-11-26 Thread mirco.malag...@ingeniaonline.it [firebird-support]
Thank you, Szilveszter. Mirco