How to speed up Django when querying large data?

• Home

  1 0 0.0 Python

  Django powered homepage (by smith153)

From experience, I've learned to not fight with the ORM much and just move straight to creating a view in the database. If you've already tried the prefetch and values() method.. then indeed the next step is to just make the database output the data in the format you need. There's https://pypi.org/project/django-database-view/ but it does not offer much help other than auto creating the view for you. I use a view on a simple blog site to count related posts. Way faster than trying to sum everything up with raw python. If you don't use that, then you could create the view yourself and then in add it manually to your models.py file as an unmanaged model.

• django-pgviews

  1 191 3.2 Python

  Fork of django-postgres that focuses on maintaining and improving support for Postgres SQL Views.

  

Ive used https://github.com/mypebble/django-pgviews for the same purpose. I like the idea that it adds the sql into git directly. Only works for postgres though.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project