I still wouldn't be content with 30 seconds - there is still something
wrong.
what's your connection string? you say local connection but something might
be up there
Alan

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of John Costanzo
> Sent: Tuesday, 15 August 2006 8:04 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Long delay when 1st connecting to database
>
>
> Hello Kevin:
>
> I am running verson 1.53
>
> --- In IBObjects@yahoogroups.com, "Kevin Stanton"
> <Kevin.Stanton@...> wrote:
> >
> > Just curious, maybe I missed this, but what version of Firebird
> are you
> > using?
> >
> > I used to have very long connects when connecting from IBO or any
> > connectivity tool when using FB 1.03.
> >
> > Once I upgraded my customer to 1.53, connecting is just about
> instantaneous.
> >
> > Kevin
> >
> >
> >
> >
> >
> > _____
> >
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
> On Behalf
> > Of John Costanzo
> > Sent: Monday, August 14, 2006 12:55 PM
> > To: IBObjects@yahoogroups.com
> > Subject: Re: [IBO] Long delay when 1st connecting to database
> >
> >
> >
> > Hello:
> >
> > I tried using IB_SQL and IBCONSOLE. Both have the same 30 second
> > delay so it obviously not an application problem. I have not read
> > the TechInfo sheet on writing client/server applications because
> > this is simply a local application. Since there is no network
> > involved my assumption was that it really didn't matter what
> > happened on the "server" since the entire application is on one
> > machine. However, I will read the TechInfo sheet. There are only 1
> > queries in the application and I honestly think that 30 is a long
> > time for such a small application but I suppose I can live with 30
> > seconds. 30 seconds sure beats 4 minutes!
> >
> > Thanks for the help
> >
> > --- In IBObjects@yahoogrou <mailto:IBObjects%40yahoogroups.com>
> ps.com,
> > Helen Borrie <helebor@> wrote:
> > >
> > > At 12:11 AM 15/08/2006, you wrote:
> > > >Hello Hellen:
> > > >
> > > >Changing the suffex helped. I changed it to .IB and now instead
> > of
> > > >4 minutes it only takes 30 seconds. Howeverm 30 seconds is a
> long
> > > >delay and I suspect many of my cliends will complain. Is there
> > > >anything else I can do to spped up connection time?
> > >
> > > Particularly don't open datasets at startup. This isn't
> > > Paradox. Hold off opening any datasets until they are actually
> > > needed. There's a thing that happens called "Prepare" that,
> > unlike
> > > in Paradox, actually interacts with the server. It fetches over
> > all
> > > of the metadata of your queries. If there are lots of them, it
> > > wouldn't be out of the park for it to take 30 seconds.
> > >
> > > Have you read the TechInfo sheet on writing client/server
> > applications?
> > >
> > > Helen
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>