[yunqa.de] Re: Insert 40 mil records with transactions
- From: Vladimir Viskovic <viskovicv@xxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Fri, 31 May 2013 17:12:12 +0200
heh i cant believe i was soooo blond stmt.free - forgot!
thanks again!
On 31 May 2013 15:08, Hennekens, Stephan <stephan.hennekens@xxxxxx> wrote:
> Hi, can you show us the source code of your test program. Looks like
> that you forget to free an object.****
>
> Regards,****
>
> Stephan****
>
> ** **
>
> ****
>
> ** **
>
> *From:* yunqa-bounce@xxxxxxxxxxxxx [mailto:yunqa-bounce@xxxxxxxxxxxxx] *On
> Behalf Of *Vladimir Viskovic
> *Sent:* vrijdag 31 mei 2013 14:59
> *To:* yunqa@xxxxxxxxxxxxx
> *Subject:* [yunqa.de] Insert 40 mil records with transactions****
>
> ** **
>
> 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:
