Subject | Re: [firebird-support] Generator Performance |
---|---|
Author | Alexey Kovyazin |
Post date | 2011-09-27T07:39:16Z |
Hello Matheus,
Run gstat -r, there will be exact information - Data Pages: NNN
CFG (149)
Primary pointer page: 2736, Index root page: 2737
Average record length: 71.20, total records: 15549
Average version length: 10.54, total versions: 48, max versions: 16
Data pages: 875, data page slots: 875, average fill: 81%
If you prefer convenient GUI interface, our IBAnalyst tool can show this
and other information in more friendly way and even calculate
tables/indices sizes in Mb.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
>Is there a way of finding out how many pages are used to store a giventable?
Run gstat -r, there will be exact information - Data Pages: NNN
CFG (149)
Primary pointer page: 2736, Index root page: 2737
Average record length: 71.20, total records: 15549
Average version length: 10.54, total versions: 48, max versions: 16
Data pages: 875, data page slots: 875, average fill: 81%
If you prefer convenient GUI interface, our IBAnalyst tool can show this
and other information in more friendly way and even calculate
tables/indices sizes in Mb.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)