Faster Django Queries With Materialized Views
Materialized views can be very useful for creating reports that will be used repeatedly. They cut down on query times because the query has already been made, and the view has been written to the disk.
In this video, Nafiul Islam demonstrates how to create materialized views, explains the benefits of using them, and shows how to integrate them into Django ORM.
00:17 – Project overview
00:43 – Color coding your tables
01:54 – Using the query console
04:21 – Creating a materialized view
05:28 – Performance with and without materialized views
05:55 – Connecting a materialized view to a Django model
07:40 – Trying out the model in the Django console
08:47 – Fixing issues arising from there being no primary key in a Django model
09:16 – Changing your materialized view
12:32 – Exporting Django ORM queries to SQL
13:30 – Using the EXPLAIN keyword
14:13 – Refreshing your materialized views
Links:
Download PyCharm: https://jb.gg/u8syo9
Watch video Faster Django Queries With Materialized Views online without registration, duration hours minute second in high quality. This video was added by user PyCharm, a JetBrains IDE 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,98 once and liked it 12 people.