title: Is there any way to improve performance while inserting rows into Oracle DB?
body: <p>I need to insert more than thousand rows into an Oracle Database table every 6 hours using VBA module. During every run some complex forecasting calculation is done in VBA and the resulting values have to be inserted into the database.</p>
  
  <p>The typical output Range consists of more than 1000 rows and 13 columns. </p>
  
  <p>Currently I insert row by row and moreover an auto-commit runs after each insert(ADO DB <em>default</em>). Is there a better method or process for improving performance here?</p>
  
  <p>It currently takes around 20 - 40 minutes depending on the server load. Any performance improvements Suggestions.</p>