Very slow pg access
| From: | Uros Gruber | Date: | Fri, 21 Jun 2002 22:51:30 +0000 |
| Subject: | Very slow pg access | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-103345@lists.php.net to get a copy of this message | ||
Hi!
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
0.087 TOTAL
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
Any thoughts.
--
tia,
Uros mailto:uros@sir-mag.com