Hi,

Is there a general guideline for the amount of page buffers ??

Nico

-----Oorspronkelijk bericht-----
Van: Brett Bandy [mailto:bbandy@...]
Verzonden: maandag 16 april 2001 19:23
Aan: ib-support@yahoogroups.com
Onderwerp: Re: [ib-support] Page buffers are zero?


I would suggest that you use gfix to set the cache buffers for the database
instead of relying on the server's default value.

gfix -buffers xxx db.gdb

Setting the cache buffers at the db level has two main advantages:

1) cache buffers will remain with database even if db is moved to different
server.
2) individual settings for each db allows for more optimal solution. If
you have a main database, say 200mb, and a smaller db, say 2mb, what do you
set the server cache setting to? No server setting will be optimal for both
of these databases.

Brett

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
To: <ib-support@yahoogroups.com>
Sent: Saturday, April 14, 2001 12:47 AM
Subject: Re: [ib-support] Page buffers are zero?


> 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@...>...
> > 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/
> >
> >
> >
>
>
>
> 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/
>
>
>



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/