× {{alert.msg}} Never ask again
Get notified about new tutorials RECEIVE NEW TUTORIALS

SQL inserting queries in a loop.

Suresh Atta
Dec 16, 2015
<p>Have a look at below code </p> <p><br>  </p> <pre><code class="language-java">loop begin insert sql in db loop end</code></pre> <p> </p> <p>Never and ever do that. Because it decrease the perofmance and alot time consuming.</p> <p> </p> <p>Solution for that is always go for a batch update.</p> <p> </p> <pre><code class="language-java">batch loop begin batch.add (insert sql in db ) loop end execute batch</code></pre> <p>That solves the purpose with less time consuming and optimised way.</p> <p> </p>
comments powered by Disqus