Just tried thru ISQL mimicing the same query with the
same parameter and it is instantaneous

How do you do TCP on a local server?

Roger

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


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