I had the same problem a year or two ago. I wish I could remember what it
was. But I still think it has to do with some connection property, or
networking property on your system.

Even though you are not using a network, try using TCP anyway, and see if it
helps.

Paul

----- Original Message -----
From: "Roger Pullen" <pullen.roger@...>
To: <IBObjects@egroups.com>
Sent: Saturday, January 13, 2001 3:52 PM
Subject: Re: [IBO] Slow first query


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