Hard to say. The SQL Trace monitor would reveal this if it were so.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Luiz Alves" <cprmlao@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, April 14, 2001 9:23 AM
Subject: Re: [IBO] Slow connection times


> I think the first connection is slow due IBO needs cache the metadata in
> your case.
>
> Luiz.
>
> ----- Original Message -----
> From: <deavewhite@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Saturday, April 14, 2001 1:14 PM
> Subject: [IBO] Slow connection times
>
>
> > I've been having some problems with slow connection times on my
> > office setup (up to 20 seconds) which I narrowed down to the
> > TIBODatabase.Connected command.
> >
> > Last night I ran some tests on my home system. The home system isn't
> > networked, so the connection times are faster, but I did discover one
> > issue which I hope somebody can explain.
> >
> > I have three Delphi applications, all compiled with the same data
> > module which connects to an Interbase database. There are a couple
> > of lines that surround the "connected" statement which time the
> > execution of this command. No matter which application I run, I
> > always get about 70ms to connect, so long as nothing else is
> > connected to the database. But if I leave the application running,
> > then start another, the connection time of the second application
> > takes about 1500ms (1.5 seconds), that's 20x longer. I also tried
> > this with IBConsole attached first, then started one of my apps, and
> > still get around 1500ms.
> >
> > Is there any reason for all but the first connection being SOOO much
> > slower?
> >
> > Running IBO 3.6
> >
> > TIA
> > --
> > Dave White
> > SpectraChrom Software
> > e-mail: dave_white@...
> > web: www.spectrachrom.com