It is local server with actual drive - ie E:\programs\database.gdb

There is no network involved

Roger

----- Original Message -----
From: "Paul Gallagher" <paul@...>
To: <IBObjects@egroups.com>
Sent: Saturday, January 13, 2001 9:41 PM
Subject: Re: [IBO] Slow first query


> I don't remember exactly what it is. But it has to do with the connection
to
> the database. Check your hosts file and see if you have it mapped properly
> to the server you are connecting to. Also try playing with connection
types,
> i.e. local or TCP
>
> Paul
>
>
> ----- Original Message -----
> From: "Roger Pullen" <pullen.roger@...>
> To: <IBObjects@egroups.com>
> Sent: Saturday, January 13, 2001 3:15 PM
> Subject: [IBO] Slow first query
>
>
> > IBO/D5 app - DB is about 60MB
> >
> > On the main screen after startup a master-detail pair of queries is run
> > - for the master just 1 record is returned, the
> > detail up to 50 records or so - linked on first field only
> >
> > First time round it takes ages - 30 seconds plus
> > (on local server so there is no network to blame)
> >
> > Second and subseqent queries run fine. Even restarting
> > the app is fine but when I re-boot the PC it is back to
> > slow first time
> >
> > I am very puzzled - I have indexes on all the linked fields (2)
> > and have tried the schemadir but to no avail.
> >
> > I feel there is some sort of cache or similar involved here
> >
> >
> > Regards
> >
> >
> >
> > Roger Pullen
> >
> >
> >
> >
> >
> >
> >
>
>
>
>