pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Maximum Execution Timeout Error!! 3+ messages / 3 participants [nested] [flat]
* Maximum Execution Timeout Error!! @ 2001-12-19 09:28 Gurudutt <guru@indvalley.com> 0 siblings, 2 replies; 3+ messages in thread From: Gurudutt @ 2001-12-19 09:28 UTC (permalink / raw) To: pgsql-php@postgresql.org; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Maximum Execution Timeout Error!! @ 2001-12-19 11:45 Martín Marqués <martin@bugs.unl.edu.ar> parent: Gurudutt <guru@indvalley.com> 1 sibling, 0 replies; 3+ messages in thread From: Martín Marqués @ 2001-12-19 11:45 UTC (permalink / raw) To: Gurudutt <guru@indvalley.com>; pgsql-php@postgresql.org; +Cc: pgsql-sql On Mié 19 Dic 2001 06:28, Gurudutt wrote: > 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. Optimize the options in your postmaster.conf file? Buy better hardware? > 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------ You have to change the configuration of PHP. Read your php.ini file. Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral ----------------------------------------------------------------- ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Maximum Execution Timeout Error!! @ 2001-12-19 12:23 Radu-Adrian Popescu <radu.popescu@aldratech.com> parent: Gurudutt <guru@indvalley.com> 1 sibling, 0 replies; 3+ messages in thread From: Radu-Adrian Popescu @ 2001-12-19 12:23 UTC (permalink / raw) To: Gurudutt <guru@indvalley.com>; pgsql-php@postgresql.org; +Cc: pgsql-sql 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" <guru@indvalley.com> To: <pgsql-php@postgresql.org> Cc: <pgsql-sql@postgresql.org> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-12-19 12:23 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-12-19 09:28 Maximum Execution Timeout Error!! Gurudutt <guru@indvalley.com> 2001-12-19 11:45 ` Martín Marqués <martin@bugs.unl.edu.ar> 2001-12-19 12:23 ` Radu-Adrian Popescu <radu.popescu@aldratech.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox