Java Resultsetnext Is Very Slow. Necessary to mention that the number of returned records is at most 25 and the same query in the database behaves executed normally executes in about 6 seconds. Vivekanand Binod jha wroteI am getting very low speed of resultSetnext method in while loop.
Where strSQL is string which calls a stored procedure in DB. When you develop java project use eclipse you may find that eclipse project run so slowly this can even stop your work you can do nothing but wait for eclipse project build or download maven jar files. Fetching the result of a select very slow using jdbc Hi TomOracle Version.
But while loop with resultsetnext is very slow.
I am trying to get some results from an oracle db and then insert these rows into another oracle db with using jdbc batch. Necessary to mention that the number of returned records is at most 25 and the same query in the database behaves executed normally executes in about 6 seconds. The problem is that SOMETIMES not always for some specific records the ResultSetnext method takes too long like 100 secs. Normally the resultSetnext takes about 2 12 seconds for my code and DB but some times it can take as long as several minutes.