Phil,

It would seem that you are running "a little thin" on RAM and are
running into disk/OS cache issues.


Sean

> -----Original Message-----
> From: Phil Shrimpton [mailto:phil@...]
> Sent: Tuesday, July 31, 2001 8:42 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Re: Slow first 'Query'
>
>
> On Tuesday 31 July 2001 13:09, you wrote:
>
> Hi,
>
> > > Thanks. It seams to knock a second or so off the time,
> but it still
> > > takes 12
> > > seconds for the 'first query' to run. There must be
> something else.
> >
> > Do you make a lot of use of triggers?
>
> Not really, only about 78, all of which are 'generator triggers'.
>
> The db stats are....
>
> Tables = 248
> Views = 76
> Procedures = 1735
> Triggers = 78
>
> ...but the same 'issue' happens with every database I have
> both smaller and
> larger.
>
> What night sead some more light on the matter, is that I ran
> this database on
> a machine with only 32Mb of memory, and when the 'first
> query' ran, there was
> no network traffic, but the disk on the server went crazy,
> then after that,
> every 'query' ran as normal.
>
> Cheers
>
> Phil
>
> --
> Linux 2.4.4-4GB
> 12:34am up 20 days, 22:18, 1 user, load average: 1.67, 0.65, 0.38
>