• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details

php issues : script timeout

Status
Not open for further replies.

manojoswal

Right off the assembly line
Hi there,
We are creating a solution in php / mysql where we are displaying about 1000 rows of information.

With the default php coding, the system tries to get all the information from the mysql database and then display it in one go, this causes it to timeout.

We are looking forward to know, how we can get it display one row at a time and then fetch information on the next row. Something that we see working on www.mail2web.com (though its in ASP)

Can someone help?

Manoj Oswal
 

alib_i

Cyborg Agent
A layman's solution would be .. to increase the max. script execution time
To do this .. open "php.ini" located in "C:\Windows" folder in notepad.
Scroll down where you find the following text.

Code:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30     ; Maximum execution time of each script, in seconds
max_input_time = 60	; Maximum amount of time each script may spend parsing request data
memory_limit = 8M      ; Maximum amount of memory a script may consume (8MB)

Change max_execution_time to 60 or 90 ..as you wish

-----
alibi
 

Deep

Version 2.0
why don't you use paging and limit the query with option "LIMIT"?

That will be the best solution for this....

btw moving this to Q&A...

Deep
 
Status
Not open for further replies.
Top Bottom