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

2015-11-25 Thread rgilland1...@gmail.com [firebird-support]
I have a large database. I have some tables that I believe are unnecessary and are taking up too much space. I need to prove this to the boss. to be allowed to change the system. How can I generate a report that gives me a list of table names and percentage of overall database the table is

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

2015-11-25 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [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% CUSTOMER11,960,320 0.295 PARAMFIL16,384 1 0.000 POSTCODES

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 > POSTC

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 Oldes

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: [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 POS

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 > Chec

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

2015-11-29 Thread rgilland1...@gmail.com [firebird-support]
Hi Alan, I have the latest personal edition of ibExpert. And quite unfortunately. It does not have a second tab. Kind Regards, Robert.

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

2015-11-29 Thread rgilland1...@gmail.com [firebird-support]
Hi Thomas, I can see that, but how does that help me find the overall percentage of the database size. Unless I know the total amount of pages being used by the database. I have been googling to find out this information without much luck. Kind Regards, Robert.

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

2015-11-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]