Source is Oracle database and it is fetching about 500,000 records from a table. I'm writing this result into another database. The process is taking about 5 minutes after using batch processing (batches of 50, I tried using more than 50 but it is not making much of a difference).
Is there an efficient way to do this? Can the process run faster, like in a minute or so?