You will obviously need to have TCP installed on your machine, but then just
change from cpLocal to cpTCP. You could also try putting the IP address in
the server property.

Something about Interbase, in that it prefers TCP over anything else. Don't
ask me why though. Pose the question to one of the Interbase groups, and
someone like Ann Harrison will explain it properly.

Paul

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


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