Django Query Optimization: Defer, Only, and Exclude

Want to learn how to build this?

Check out the post.

Want to use this project?

1. Fork/Clone

2. Create and activate a virtual environment:

   $ python3 -m venv venv && source venv/bin/activate

3. Install the requirements:

   (venv)$ pip install -r requirements.txt

4. Apply the migrations:

   (venv)$ python manage.py migrate

5. Populate the database:

   (venv)$ python manage.py populate_db

6. Run the server:

   (venv)$ python manage.py runserver

7. Navigate to http://localhost:8000/ in your browser.

Benchmark

The project comes with django-silk preinstalled, which you can use for checking the performance of the SQL queries: http://localhost:8000/silk/.