Performance Issue with writing Spark Dataframes to Oracle Database
<p>I am trying to write to save a Spark DataFrame to Oracle. The save is working but the performance seems to be very poor.</p>

<p>I have tried 2 approaches using </p>

<ol>
<li><code>dfToSave.write().mode(SaveMode.Append).jdbc(…)</code>  --  I suppose this uses below API internally.</li>
<li><code>JdbcUtils.saveTable(dfToSave,ORACLE_CONNECTION_URL, "table",props)</code></li>
</ol>

<p>Both seem to be taking very long, more than 3 mins for size of 400/500 rows DataFrame.</p>

<p>I hit across a JIRA SPARK-10040 , but says it is resolved in 1.6.0 and I am using the same.</p>

<p>Anyone has faced the issue and knows how to resolve it?</p>