[yunqa.de] Insert 40 mil records with transactions

  • From: Vladimir Viskovic <viskovicv@xxxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Fri, 31 May 2013 14:58:47 +0200

Hello,
for a test i want to insert 40 million records in sqlite db
using delphi XE3
with transactions speed was increased a lot, but also memory consumptions
get VERY high
for example every 100 000 records i do commit and then add another
transaction but memory is not freed up?! it goes till 2gb on my XP machine
and ofcourse crashes SQLite-7 out of memory.
Is there any way to free up memory?

regards,
V.

Other related posts: