Thread: Maximum time execution time error
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.
On Mon, 28 May 2001, omid omoomi wrote: > 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 > > Any Idea about the reason and the way to fix it ? I think that this is php's issue so you should fine tune your php-settings: A sniplet from my php.ini (php 4.x): ;;;;;;;;;;;;;;;;;;; ; Resource Limits ; ;;;;;;;;;;;;;;;;;;; max_execution_time = 30 ; Maximum execution time of each script, in seconds memory_limit = 8M ; Maximum amount of memory a script may consume (8MB) -- 8< -- Current settings + other funky stuff are viewable by following sniplet: <?php phpinfo(); ?> BR, Jani --- Jani Averbach
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