Hands-On Enterprise Application Development with Python

Summary

In this chapter, we learned about how to build database models that can help us make our application performant when dealing with data on a large scale. We saw how optimizing a model can be the first stage of optimization, and how it can help us make our application more maintenance-friendly, by reducing coupling across database models. We then moved on to cover how indexes can be useful for making accessing data inside the database faster, by indexing columns that are more frequently accessed.

We later covered one of the important aspects of maintaining the consistency of the database, through the use of transactions.

The final part of the chapter covered data loading techniques, such as lazy loading, eager loading, and no loading, ...