note afoken <p>Some ideas:</p> <ul> <li>Move the <c>prepare</c> out of the <c>while</c> loop. No need to prepare the same statement more than once.</li> <li>Use [mod://DBI|placeholders] to get rid of SQL injection problems, and to improve performace by allowing to cache the prepared statement inside the database engine.</li> <li><c>prepare</c> the insert statement outside the <c>while</c> loop, and use placeholders, for the same reasons.</li> <li>Disable auto-commit, and commit manually every few thousand rows, [http://www.sqlite.org/faq.html#q19|as recommended by the SQLite FAQ].</li> </ul> <p>Alexander</p> <div class="pmsig"><div class="pmsig-747201"> --<br> Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-) </div></div> 1019191 1019191