Performance issue when calling Oracle functions
Posted on 2008-06-19
My Java code calls a plsql function continuosly for roughly around 100 to 150 times with various parameters.
I gather information in a hashtable and call this plsql function in a loop and the output of each call would be one of the inputs for the next call.
As the program progresses the time it takes to complete each iteration is increasing exponentially...