Faster Django Queries With Materialized Views
5.7 هزار بار بازدید -
2 سال پیش
-
Materialized views can be very
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
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
2 سال پیش
در تاریخ 1401/04/14 منتشر شده
است.
5,722
بـار بازدید شده