Re: [sqlite] help with huge bulk inserts

On 17 Aug 2010, at 12:16am, Maciej Kurczewski wrote: > I'm using sqlite as a data storage backend for my log parsing application. > I have around 7 milion - equals to 1GB of binary log (up to 35 mln.) > records to insert at once, I'm using prepared statments, huge > transactions, and optimised (I

[sqlite] help with huge bulk inserts

Hello, I'm using sqlite as a data storage backend for my log parsing application. I have around 7 milion - equals to 1GB of binary log (up to 35 mln.) records to insert at once, I'm using prepared statments, huge transactions, and optimised (I hope) pragma settings: PRAGMA journal_mode = OFF; PRAGM