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