YoVDO

From Days to Minutes, From Minutes to Milliseconds with SQLAlchemy

Offered By: EuroPython Conference via YouTube

Tags

EuroPython Courses Software Development Courses Python Courses Database Optimization Courses SQLAlchemy Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore how to optimize database queries and operations using SQLAlchemy in this 45-minute EuroPython Conference talk. Learn to identify and solve the N+1 query problem, implement mass inserts and updates, and dramatically improve application performance. Discover practical solutions for transforming slow database interactions from days to minutes, and from minutes to milliseconds. Gain insights applicable to most ORMs and storage back-ends, making this talk valuable for Python developers working with databases at any scale.

Syllabus

Introduction
Im no expert
Our stack
SQL Alchemy
Frameworks
Python code
Volumes
Implicit queries
Queries
Round Trips
Giroux
Bencher
Code
Convenience attribute
Model serial number
Dynamic Relationships
Debugging
Reading the code
Column Sum
Scholar Method
Further Filtering
Single Hit
Insertion Optimization
Python List
Giant Load
SlowLog


Taught by

EuroPython Conference

Related Courses

A Brief History of Data Storage
EuroPython Conference via YouTube Breaking the Stereotype - Evolution & Persistence of Gender Bias in Tech
EuroPython Conference via YouTube We Can Get More from Spatial, GIS, and Public Domain Datasets
EuroPython Conference via YouTube Using NLP to Detect Knots in Protein Structures
EuroPython Conference via YouTube The Challenges of Doing Infra-As-Code Without "The Cloud"
EuroPython Conference via YouTube