Improve INSERT-per-second performance of SQLite

Optimizing SQLite is tricky. Bulk-insert performance of a C application can vary from 85 inserts per second to over 96,000 inserts per second! Background: We are using SQLite as part of a desktop application. We have large amounts of configuration data stored in XML files that are parsed and loaded into an SQLite database for further processing when the application is initialized. SQLite is ideal

[excer]

チューニングの話

[laysakura]

SQLiteで864,913レコードINSERTする話．TRANSACTIONでまとめるとまとめないとで速さが数百倍違うのが興味深い．メインのポスト以外にも，Snazzerさんのポストは有用