Phil,

I'm confused! I thought you said that you were running on a machine
with 32mb of RAM?

WRT the cache allocation, yes, I would suspect that the cache is not
allocated until the database is opened --the first connection is opened.


Sean

> -----Original Message-----
> From: Phil Shrimpton [mailto:phil@...]
> Sent: Tuesday, July 31, 2001 9:27 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Re: Slow first 'Query'
>
>
> On Tuesday 31 July 2001 23:56, you wrote:
>
> Hi,
>
> > It would seem that you are running "a little thin" on RAM and are
> > running into disk/OS cache issues.
>
> I hope not (the server has 768Mb, DB 10000 pages @ 8K, no
> disk rattles).
> Whilst it is worse, with lots of disk rattling, on a machine
> with less
> memory, I stil don't understand what it is doing, does it
> not allocate the
> cache untill the 'first query' is run?
>
> Cheers
>
> Phil
> --
> Linux 2.4.4-4GB
> 1:19am up 20 days, 23:02, 1 user, load average: 0.90, 0.71, 1.01
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Secure your servers with 128-bit SSL encryption! Grab your
> copy of VeriSign's FREE Guide: "Securing Your Web Site for
> Business." Get it Now!
> http://www.verisign.com/cgi-bin/go.cgi?a=n094442340008000
> http://us.click.yahoo.com/n7RbFC/zhwCAA/yigFAA/dpFolB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/