I don't use pconnect - there has been reports of the driver not releasing
the connection properly.
try it with connect and show the timings as well
Alan
-----Original Message-----
From: marcdecaluwe [mailto:marcdecaluwe@...]
Sent: Friday, October 29, 2004 9:19 AM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] ibase_connect pconnect




I am using Apache 1.3 - PHP 4.3 - Firebird 1 for some development.
Everything is working well but I wished I could improve execution time
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?
Anyone with good ideas?

Thanks!

Marc







Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]