Skip to content

Latest commit

 

History

10 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:

  1. In a transaction.
  2. As a prepared statement.
  3. 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).

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages