in reply to Re^2: processing slows way down
in thread processing slows way down

how could it be a scope issue?

Without seeing the code, there really is no way to tell where the problem might lie. That's why I offered the suggestion on how you could check the problem out.

It could be that there is a leak in one of the components your using to access Oracle. The simple test there is to comment out the DB code within the loop and re-run the script. If that stops the memory growth, you know where to look. If it doesn't, you also know where.

All of which is pure speculation until you perform the test to see if memory leakage is the cause of the slowdown.

Another possibility is that you are misusing DBI. There have been examples of code here at PM where people have been preparing their statements each time around the loop, rather than once outside and then executing them inside.

Again, without sight of the code, pure speculation.


Examine what is said, not who speaks.
"Efficiency is intelligent laziness." -David Dunham
"Think for yourself!" - Abigail
"Memory, processor, disk in that order on the hardware side. Algorithm, algoritm, algorithm on the code side." - tachyon

Replies are listed 'Best First'.
Re^4: processing slows way down
by Anonymous Monk on Jul 11, 2004 at 00:42 UTC
    Ok, thank you BrowserUk.

    I will look into what you describe and try to get back here with what happened.