From: | "Radu-Adrian Popescu" <radu(dot)popescu(at)aldratech(dot)com> |
---|---|
To: | "Gurudutt" <guru(at)indvalley(dot)com>, <pgsql-php(at)postgresql(dot)org> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: [SQL] Maximum Execution Timeout Error!! |
Date: | 2001-12-19 12:23:56 |
Message-ID: | 001301c18888$07a97380$0600a8c0@rpopescu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php 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(at)indvalley(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)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(at)indvalley(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | andrebotelho | 2001-12-25 22:06:17 | |
Previous Message | Martín Marqués | 2001-12-19 11:45:27 | Re: Maximum Execution Timeout Error!! |
From | Date | Subject | |
---|---|---|---|
Next Message | Giorgio Ponza | 2001-12-19 13:03:50 | Stupid question on INDEXES |
Previous Message | Martín Marqués | 2001-12-19 11:45:27 | Re: Maximum Execution Timeout Error!! |