Speed benchmarking SQLite from Python

Posted on Updated on

Sqlite

On the SQLite homepage is a database speed comparison. There SQLite compares somewhat favorably to PostgreSQL and MySQL if you do not consider non-transactional inserts.

I have not yet gotten around to test PostgreSQL and MySQL, but I managed to get my first short SQLite benchmark written with testing from Python. As indicated on the SQLite speed comparison non-transactional inserts are expensive, and that is what I also find.

https://gist.github.com/701922

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s