database slow question

new_programmer

Can someone help me in following questoin

A reporting script is run from the command line that takes about 45 minutes to run against the production database. Towards the end of run of the script, the database becomes heavily loaded and starts to affect other applications using that databaes.

How to approch debugging that script?

I dont have the script, i just need to know what would be the best way to debug

Piranha

After this thread and this one I am sure that you want help with your schoolwork. Schoolwork is to let you learn from it, not for you to let someone else do it for you.

If I'm wrong about this I recommend that you read a few tutorials and google a bit, some good words would be debugging and optimizing.

new_programmer

Piranha wrote:
After this thread and this one I am sure that you want help with your schoolwork. Schoolwork is to let you learn from it, not for you to let someone else do it for you.

If I'm wrong about this I recommend that you read a few tutorials and google a bit, some good words would be debugging and optimizing.

Thank you for the direction