Very Computer

by **omid omoom** » Tue, 29 May 2001 17:33:40

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)---------------------------

by **Jani Averba** » Tue, 29 May 2001 17:51:08

> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

by **fabrizio.erm..** » Tue, 29 May 2001 18:46:43

> 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)---------------------------

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:

loc. Meleto Valdarno Mail on GSM: (keep it short!)

---------------------------(end of broadcast)---------------------------

Very Computer

Maximum time execution time error

Maximum time execution time error

Maximum time execution time error

Maximum time execution time error