Subject Re: [IB-Architect] UDF replacement: native shared libraries vs. J ava
Author Jason Chapman
Does the cache just work on Most Recently Used or does it prioritise Indexes
or special pages? If it doesn't then NT & IB caches duplicate and interfere
with each other, therefore I could have saved some cash on memory.


----- Original Message -----
From: Bill Karwin <bill@...>
To: <>
Sent: Tuesday, April 18, 2000 8:40 AM
Subject: Re: [IB-Architect] UDF replacement: native shared libraries vs. J

> InterBase has an arbitrary limit hardcoded for its data cache at 512MB.
> I don't remember if there's any driving reason behind it, it's just a
> limit.
> I believe it is 512MB _per database_, since Superserver allocates a
> separate cache for each database that is currently active on the server.
> I think it would be ideal if ibserver set the limit at the maximum
> amount of physical RAM on the system (or perhaps leaving some amount for
> operating system use). It would be pointless to allocate 1GB of cache
> on a system with 128MB of physical RAM.
> This assumes that each supported OS has a function to report the amount
> of RAM.
> Bill
> Jason Chapman wrote:
> >
> > > As I understand it, without adjusting some of the IB parameters, in
> > > fact, your 1gb of RAM may not actually being used for the db (or by
> > > the OS).
> > >
> > > I recall reading somewhere that NT uses a maximum of 512Mb for it's
> > > file cache. In that case, you would need to specifically configure IB
> > > order to it to "force" the other 512mb to be used for it own purposes.
> >
> > Why wouldn't it if it is the only significant process running. Moving
> > a 512MB configuration to a 1GB configuration makes a significant
> > in performance.
> ------------------------------------------------------------------------
> Avoid the lines and visit for quick and easy online
> reservations. Enjoy a compact car nationwide for only $29 a day!
> Click here for more details.
> ------------------------------------------------------------------------
> To unsubscribe from this group, send an email to: