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