Received: from www.aldratech.com ([213.157.162.9]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBJCNBm97985; Wed, 19 Dec 2001 07:23:12 -0500 (EST) (envelope-from radu.popescu@aldratech.com) Message-ID: <001301c18888$07a97380$0600a8c0@rpopescu> From: "Radu-Adrian Popescu" To: "Gurudutt" , Cc: References: <4419501758.20011219145851@indvalley.com> Subject: Re: [SQL] Maximum Execution Timeout Error!! Date: Wed, 19 Dec 2001 14:23:56 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Received: from 192.168.0.6 ([192.168.0.6]) by mail.aldratech.com (JAMES SMTP Server 1.2.1rc2) with SMTP ID 208; Wed, 19 Dec 2001 15:30:40 +0200 X-Archive-Number: 200112/24 X-Sequence-Number: 799 Regarding the 30" timeout, you should edit your php.ini and modify the line that reads max_execution_time = 30 Also try to human-optimize your queries, use EXPLAIN to analyse you query plans, throw in some indexes, bla-bla-bla. You should be able to get more help when providing some pieces of code/db structures/EXPLAIN outputs etc. Good luck till then. -- Radu-Adrian Popescu CSA, DBA, Programmer Aldratech ----- Original Message ----- From: "Gurudutt" To: Cc: Sent: Wednesday, December 19, 2001 11:28 Subject: [SQL] Maximum Execution Timeout Error!! > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html