This benchmark does not intend to be exhaustive nor fair to SQL. It shows how django-cachalot behaves on an unoptimised application. On an application using perfectly optimised SQL queries only, django-cachalot may not be useful. Unfortunately, most Django apps (including Django itself) use unoptimised queries. Of course, they often lack useful indexes (even though it only requires 20 characters per index…). But what you may not know is that the ORM currently generates totally unoptimised queries .
In this benchmark, a small database is generated, and each test is executed 20 times under the following conditions:
|CPU||Intel(R) Core(TM) i7-7700HQ CPU @ 2.80GHz|
|Linux distribution||Ubuntu 18.04 bionic|
Note that MySQL’s query cache is active during the benchmark.
- mysql is 1.1× slower then 4.0× faster
- postgresql is 1.1× slower then 9.0× faster
- sqlite is 1.2× slower then 4.3× faster
- filebased is 1.2× slower then 5.8× faster
- locmem is 1.1× slower then 6.1× faster
- memcached is 1.1× slower then 5.0× faster
- pylibmc is 1.1× slower then 5.6× faster
- redis is 1.1× slower then 5.6× faster
|||The ORM fetches way too much data if you don’t restrict it using