On 26/09/11 17:06, Ann Harrison wrote:
Is there a way of finding out how many pages are used to store a given
table? Or documentation about how the mapping from tables to memory and
disk pages are implemented on firebird?
Maybe
Hello Matheus,
Is there a way of finding out how many pages are used to store a given
table?
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
Hello Matheus,
Generator values are stored on generator pages. In shared cache
architectures (i.e. SuperServer) a connection that changes a generator
value
gets a transient write lock on the page, makes its change and releases
the
page.
This page is the mapping of a set of table