I find it impossible that PHP should be "slow". PHP's Pg functions are -
and shouldn't be - nothing more or else than a frontend to the Pg API.
The problem is most likely that you are not comparing the same values. I
think the analyze values are calculated "internal" values that has little
to do with real life through an API.
Postgres is very fast - but a connect and 3 queries in 0.002 ms? Hmmm!
The 0.1 s looks more like a "real" value to me.
At 00:51 22/6/2002 +0200, you wrote:
>i made some benchmarks because my script is somehow very
>slow. In this script i execute 3 queries to PostgreSQL server
>and one connect string. I connect to socket.
>I check this queries in pg with explain analyze and i have
>result 1.18ms so i add a little and let say that for those 3
>queries need 2ms. (1 simple select, 1 delete, 1 insert)
>When i check from PHP i use microtime() to check times.
>Here is results
>0.0443 for connect
>0.0343 1 query delete
>0.0034 2 query select
>0.0049 3 query THIS ONE is INSERT OR UPDATE
>so complete time is about 0.090 s this is 90ms against 2ms. I
>thik that this is not normal. or is PHP so slow or there is
>something wrong with libraries
>I use PHP 4.1.2 and pg 7.2.1
> Uros mailto:[EMAIL PROTECTED]
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php