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
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
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:
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
4 matches
Mail list logo