performance problems

admin

Administrator
Staff member
hi,

i have to select about 40000 rows and process all these rows, one by one, in a php function for making a file for customers use.

i use a loop like this :

while (list($i,$j) = mysql_fetch_rows(.....)
{
commands
}

php tells me : max execution time error on line XXX.

i've trie the set_execution_time(10000) on the script but the error is always here.

i'm working on a server that is not in my country and i'm not allowed to modify php or mysql parameters, such as max_exec_time or cache for mysql.

The version of mysql is 3-22.27, an old version and php is PHP Version 3.0.12
with Apache 1.3.9

have you tips for improve big loads of row with php and mysql ??????

thanks a lot
 
Back
Top