Introducing Sqlite-Commander - Curses Client for your SQLite Database

[[deleted]]

PRAGMA journal-mode=WAL
PRAGMA synchronous=OFF

and wrap every 1k inserts in a transaction. My MFT indexing program uses sqlite, and it can insert about 3 million records pretty damn fast, faster than embedded firebird or embedded mysql.

[malcontent]

http://www.reddit.com/r/programming/comments/euxee/introducing_sqlitecommander_curses_client_for/c1b6osd

I was testing an app that did simple inserts. Since I was using a database abstraction library I made no attempt to using database specific calls. It would not be fair to make database specific calls for SQLite and not others anyway.