Stored procedure takes a REALLY LONG time to finish when called by the application
Posted on 2007-10-09
I have a Sybase stored procedure that will basically insert 50.000 records on a table. When I call this procedure directly from the database, it takes less than a minute to run.
However, when I call it from my Java application, it is taking forever to run! I waited for 30 minutes, then I gave up.
What should be the problem here? Any ideas?
Thanks in advance.