Subject | Re: [ib-support] Page buffers are zero? |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-04-14T07:47:48Z |
Page buffers=0 in the db (as reported by gstat, for example) means the
server's default is in place. If you want to change the server default in
the configuration file, you must also remove the # in front of the line, it
means a comment!
Take a look at
http://www.cvalde.com/document/cache_settings_priority.htm
It explains the priority of settings, because they aren't obvious.
C.
<deavewhite@...> wrote in message news:<9b7j2h+qk18@...>...
server's default is in place. If you want to change the server default in
the configuration file, you must also remove the # in front of the line, it
means a comment!
Take a look at
http://www.cvalde.com/document/cache_settings_priority.htm
It explains the priority of settings, because they aren't obvious.
C.
<deavewhite@...> wrote in message news:<9b7j2h+qk18@...>...
> 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*
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>