php issues : script timeout

[manojoswal]

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

 

[praka123]

i think you will get better answers in some Prof. php forums....like
*www.php.net/mailing-lists.php
Best of LUX

 

[alib_i]

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.

;;;;;;;;;;;;;;;;;;;
; 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]

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