Subject | ibase_connect pconnect |
---|---|
Author | marcdecaluwe |
Post date | 2004-10-28T23:19:12Z |
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
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