Long Execution

[Anon]

There is a script and it takes about 25 seconds to execute, what it basically does is gets up to 80 sets of input data and calculates around 40 calculations for each. It gets the input data from a MySQL database.

How can I increase execution time?
Help would be extremly apprecitated.

[Anon]

Hi,

Instead of doing this in one shot, you can break it in smaller task which will take less time to execute. You can use file or database to store intermidiate results.

I think it will help you if think in above manner.

Regards,
Teena

[herve]

You can increase the value of the
"max_execution_time" variable (in seconds)
in your php.ini file.

setting it to 120 means a script has 2 min.
to complete its job.

[matto]

Got two hints worth a try:

Instead of changing max_execution_time in php.ini, you can use the set_time_limit function for single scripts.

Furthermore, if you have many huge repeated joins to calculate, you could think of using a temporary table. I once increased speed in a cross-calculation table generation script by more than 10 times using a temp table that holds the basic join. I queried this table for the single selects.

And, I was told that dropping and re-creating the temp table every time was notably faster than doing a delete from each time. (I had to deal with >5000 records per script.)

perhaps this helps you.