Re: Maximum time execution time error

On 28 May 2001, at 8:19, omid omoomi wrote:

> Hi all,
> I have a select statement joining two tables ( t1 and t2 ) inside a php
> program running on apache server.
> table t1 has about 700 records.
> table t2 has about 150000 records.
> I got this error while trying to run the query on the web server:
>
> Fatal error: Maximum execution time exceeded in
> /usr/local/apache/htdocs/mis/applic1/perucomparet.php3 on line 62
>
> The platform is :
> FreeBSD 3.2
> PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1
> Apache 1.3.9
>
> Any Idea about the reason and the way to fix it ?
> TIA
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

Your query is getting more than 30 sec. to be executed. You really
should consider to create some index to speed it up...

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

Fabrizio Ermini Alternate E-mail:
C.so Umberto, 7 faermini(at)tin(dot)it
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini(at)sms(dot)tin(dot)it