I'm using Firebird 1.0.0.
Connection times vary from 0.2 sec to over 2sec.


--- In firebird-php@yahoogroups.com, "Ard Biesheuvel"
<a.k.biesheuvel@e...> wrote:

>
> --- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
>
> > of some pages. I have been analysing the pages with timers and it
> > seems that alls SQL command seem to run rather fast, but to my
> > surprise the time to make a connection to the database

(ibase_connect)

> > and the FIRST SQL statement seem to take about 80% of all the

time the

> > script needs to run. Even if I change the first SQL statement,
> > execution time can vary a bit depending on the statement itself, but
> > it always takes a LOT more time than when I execute it as a second.
> > I experimented also a bit with ibase_pconnect but couldn't find any
> > improvement. Maybe I'm missing something somewhere?
>
> Are you using the most recent release of Firebird 1 (not 1.5) ?
> IIRC, at some

point a bug was fixed that caused connection requests to

> be delayed for some time for no reason.
>
> --
> Ard