> > If you are using Derby in embedded mode, I do not think there will be a > performance advantage of using a stored procedure over executing the code > directly in the application. It may even be faster to skip the stored > procedure. It would be interesting if you could try it out and report the > results. >
I change this function and execute it from Java application directly, not as stored procudere. Results looks like the same. Near 12-14 seconds.
