From: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | Gurudutt <guru(at)indvalley(dot)com>, pgsql-php(at)postgresql(dot)org |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Maximum Execution Timeout Error!! |
Date: | 2001-12-19 11:45:27 |
Message-ID: | 20011219114530.36A6CFD1C@bugs.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php 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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Radu-Adrian Popescu | 2001-12-19 12:23:56 | Re: [SQL] Maximum Execution Timeout Error!! |
Previous Message | Gurudutt | 2001-12-19 09:28:51 | Maximum Execution Timeout Error!! |
From | Date | Subject | |
---|---|---|---|
Next Message | Radu-Adrian Popescu | 2001-12-19 12:23:56 | Re: [SQL] Maximum Execution Timeout Error!! |
Previous Message | Gurudutt | 2001-12-19 09:28:51 | Maximum Execution Timeout Error!! |