I am looking for a better way in performance to handle bulk data from remote Oracle into PostgreSQL in local ( 50,000 rows ).
Currently, just using PreparedStatement and insert the data in a loop with a RecordSet.
Dim ps As PostgreSQLPreparedStatement
Thinking of generating a file and load it into PostgreSQL by psql command.
I am wondering if there is any other nice method to improve this logic.
Memory processing or by Dictionary?