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
>
>
>
>
>
>
>