On Monday 30 July 2001 10:11, you wrote:

Hi,

> > The first 'query' after
> > connecting to the database takes forever and after that all
> > 'queries' run like s**t off a shoval.
>
> Hi, Phil. If there are many indexes and referential constraints in
> your database, I can recommend add
>
> CREATE INDEX RDB$INDICES_IDX1 ON
> RDB$INDICES (RDB$FOREIGN_KEY)

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.

Cheers

Phil

--
Linux 2.4.4-4GB
10:36am up 20 days, 8:20, 1 user, load average: 0.88, 0.52, 0.29