Go Sqlite Insert Test
These are some tests of Sqlite (using mattn's go-sqlite3 bindings) insert performance following the findings from this stackoverflow link.
Inserts are tested by inserting random strings against a table:
CREATE TABLE FOO (
ID PRIMARY KEY,
NAME VARCHAR(20)
);simpleTest.go
Performs serial inserts (ie one after the other), no concurrency:
- In a transaction.
- As a prepared statement.
- Plain insert.
User an specify sqlite or postgres via cmdline args.
httpTest.go
Simple http server that performs an insert per request. Uses either postgres or sqlite (via cmdline args). This is to test concurrent inserts (via testing with Apache ab for example).