This is a tiny django benchmark, that measures some common operations:
- creating objects in bulk (using
model.objects.bulk_create) - creating objects one at a time
- updating objects one at a time
- querying objects one at a time (accessing ForeignKey field)
- selecting a lot of objects using
model.objects.all - selecting a lot of objects using
model.objects.all().values_list - selecting a lot of objects using
cursor.fetchall
The goal is not to measure the raw speed
of Postgres bindings, but to evaluate them in a way similar to the way
they are used in real-life web applications. Although cursor.fetchall
benchmark does not use Django directly.
A write-up with benchmark results lives here TODO
Install:
pip install -r requirements.txt
Run:
./bench 1000
It will run the benchmark several times, to give PyPy JIT time to warm up.
It will create a test database named psycopg2_cffi_test_db, and
by default will try to access it without password and using you system
user name - you can change it in settings.py.