My application receives a query result from Oracle and uses PreparedStatement to issue INSERT statements(into PostgreSQL).
It works but in case the number of result is over 3000 rows then it slows.
So, I am considering to save the result into a local file and runs PostgreSQL's direct load feature to speed it up.
Database resultSet: rs.
I know how to create a file and iterates the result set until EOF.
But I want to check if there is any efficient method to save the ResultSet into a file fast.
Do you have any idea on it?