Re: Maximum time execution time error
От | fabrizio.ermini@sysdat.it |
---|---|
Тема | Re: Maximum time execution time error |
Дата | |
Msg-id | 3B123758.21488.DF0D772@localhost обсуждение исходный текст |
Ответ на | Maximum time execution time error ("omid omoomi" <oomoomi@hotmail.com>) |
Список | pgsql-general |
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@postgresql.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@tin.it loc. Meleto Valdarno Mail on GSM: (keep it short!) 52020 Cavriglia (AR) faermini@sms.tin.it
В списке pgsql-general по дате отправления: