Time demanding calculations.

[Rene_D]

Hi there

I have a script running a lat of mysql requests. It takes about 3 minutes to run.

But in the mean time my server is not responding to other requests, or running very slow.

How do I make the calculations without bringing the server down temporarily?

Can I assign some kind of priority telling PHP not to user 100% CPU power to run the script?

Kind regards Rene.

[superwormy]

I've seenissues like this as well, I'd first reccomend trying to optimize the query/add indexes/optimize yoru script so it doesn't take so long. Then I'd try running it at night when there'll be less usage of the database.

Aside from that, you might also try sleep() to sleep the script for a second or so between each MySQL request to give other requests a chance...