Very slow pg access

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

« previous php.general (#103345) next »