You are using the same machine, right?
Have you thought that the first time, the db pages should be loaded in IB
cache and also, that IB is competing for OS page faults with your
application and other executables and so on?

C.

> -----Original Message-----
> From: Roger Pullen [mailto:pullen.roger@...]
> Sent: Sábado 13 de Enero de 2001 17:15
> To: IBObjects@egroups.com
> 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
>
>
>
>
>
>
>