Received: from gateway.indvalley.com (ptil-134-144-ban.primus-india.net [203.196.144.134] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id fBJ9Wnm76803 for ; Wed, 19 Dec 2001 04:32:50 -0500 (EST) (envelope-from guru@indvalley.com) Received: (qmail 2975 invoked from network); 19 Dec 2001 09:32:25 -0000 Received: from unknown (HELO GURU) (192.168.0.20) by 192.168.0.63 with SMTP; 19 Dec 2001 09:32:25 -0000 Date: Wed, 19 Dec 2001 14:58:51 +0530 From: Gurudutt X-Mailer: The Bat! (v1.52f) Reply-To: Gurudutt Organization: Indus Valley X-Priority: 3 (Normal) Message-ID: <4419501758.20011219145851@indvalley.com> To: pgsql-php@postgresql.org CC: pgsql-sql@postgresql.org Subject: Maximum Execution Timeout Error!! MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/22 X-Sequence-Number: 797 Hello, I am using POSTGRESQL Version 7.1.3 and PHP to implement a call center software. We have real -time updations and querying on the database almost every 30 seconds. I am using PEAR DB to realize data abstraction layer. I am regularly doing VACUUM ANALYZE. I don't know what is making the system to be very slow, but it takes nearly a minute plus execution time to do simple fetch operations. How do I make the system, to perform much faster. Sometimes I also get the following error.. ------- ERROR STARTS------ Fatal error: Maximum execution time of 30 seconds exceeded in DB/pgsql.php on line 163 ------- ERROR ENDS------ -- Best regards, Gurudutt mailto:guru@indvalley.com Life is not fair - get used to it. Bill Gates