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