Re: [sqlite] WAL mode

2017-02-08 Thread Niti Agarwal
Yes, I am closing the DB before program exits. Like this: db.Close(). I am using Sqlite3 with Golang. Regards, Niti On Wed, Feb 8, 2017 at 11:08 PM, Jens Alfke <j...@mooseyard.com> wrote: > > > On Feb 8, 2017, at 9:21 AM, Niti Agarwal <n...@ionosnetworks.com> wro

[sqlite] WAL mode

2017-02-08 Thread Niti Agarwal
The databases I'm working with are write ahead logging (WAL) databases. According to the SQLite documentation, the shm and wal files are supposed to be deleted upon completion of the program. However, these files are still there after execution of this program. The documentation says the files

Re: [sqlite] Bulk Insert in Sqlite3

2017-02-06 Thread Niti Agarwal
panic(err) } if err1 != nil { panic(err1) } fmt.Println("doing rollback") tx.Rollback() } else { tx.Commit() } } On Tue, Feb 7, 2017 at 11:56 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Feb 2017, at 5:36am, Niti Agarwal <n...@ionosnetworks.com> wrote:

[sqlite] Bulk Insert in Sqlite3

2017-02-06 Thread Niti Agarwal
Hi, We are using Sqlite3 with Golang to do bulk insert. Need to insert close to 10 Million records to sqlite3 in around 30 mins. Currently I am saving 100 Records under one transaction with below settings: PRAGMA synchronous = NORMAL; PRAGMA journal_mode = WAL; PRAGMA