Subject | Page buffers are zero? |
---|---|
Author | deavewhite@yahoo.com |
Post date | 2001-04-13T19:12:17Z |
We've been seeing progressively longer connection times (currently
about 10 seconds to connect to the remote database over a 100MB/s
TCP/IP connection) and think it may be a cacheing problem as the
database gets larger.
When I check the statistics for our database, the "Page buffers" are
reported as zero. It's actally a very small database at present -
only about 2MB. I set the #DATABASE_CACHE_PAGES parameter to 5000 in
the ibconfig file (Windows NT with 256MB RAM) but can't seem to get a
reading for Page buffers. Am I missing something?
TIA
Dave White
Database "d:\autopro\lims\autopro.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 57698
Page size 4096
ODS version 10.0
Oldest transaction 56337
Oldest active 56338
Oldest snapshot 56338
Next transaction 56363
Bumped transaction 1
Sequence number 0
Next attachment ID 3
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jan 22, 2001 15:44:02
Attributes force write
Variable header data:
*END*
about 10 seconds to connect to the remote database over a 100MB/s
TCP/IP connection) and think it may be a cacheing problem as the
database gets larger.
When I check the statistics for our database, the "Page buffers" are
reported as zero. It's actally a very small database at present -
only about 2MB. I set the #DATABASE_CACHE_PAGES parameter to 5000 in
the ibconfig file (Windows NT with 256MB RAM) but can't seem to get a
reading for Page buffers. Am I missing something?
TIA
Dave White
Database "d:\autopro\lims\autopro.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 57698
Page size 4096
ODS version 10.0
Oldest transaction 56337
Oldest active 56338
Oldest snapshot 56338
Next transaction 56363
Bumped transaction 1
Sequence number 0
Next attachment ID 3
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jan 22, 2001 15:44:02
Attributes force write
Variable header data:
*END*