Skip to content

tomkins/wagtail-sqlite-benchmark

Repository files navigation

Wagtail SQLite Benchmark

Documented with GitHub issues.

Using Bakery Demo and SQLite to see how Django and Wagtail perform using SQLite as a database.

Running a benchmark

For all server and locust instructions - adjust the number of workers and users.

Initial setup

pip install -r requirements/production.txt
./manage.py migrate
./manage.py load_initial_data
./manage.py collectstatic --settings=bakerydemo.settings.production --noinput

Gunicorn

gunicorn \
    --env=DJANGO_SETTINGS_MODULE=bakerydemo.settings.production \
    --env=DJANGO_SECRET_KEY=demo \
    --workers=4 \
    bakerydemo.wsgi:application

uWSGI

uwsgi \
    --env=DJANGO_SETTINGS_MODULE=bakerydemo.settings.production \
    --env=DJANGO_SECRET_KEY=demo \
    --master \
    --http11-socket=127.0.0.1:8000 \
    --disable-logging \
    --workers=4 \
    --module=bakerydemo.wsgi

Locust

locust \
    --headless \
    --host http://127.0.0.1:8000 \
    --run-time 1m \
    --spawn-rate 4 \
    --users 4