Python can be a tricky language due to the fact that it’s dynamic. Not everyone likes this and it’s true that while it solve one group of problems, it also creates another (there are no solutions in real life, just trade-offs). I’m going to show you what can be a problem and how to solve […]
Tag: optimization
Optimizing Django Queries – Part 4
Time to say goodbye to yet another series. But before we do so, let’s once again ask the question: “how can I make Django database queries faster?” Today I’m going to show another aspect of this problem, namely leveraging the hardware architecture for optimizing Django queries. Let’s create a read replica and set up the […]
Optimizing Django Database Queries – Part 2
In the previous post about optimizing Django database queries I showed how to detect and improper use of indexes and what Django creates by default. Today I’d like to show a better usage of indexing on a potentially expensive operation which is text searching. Task: Search an Author By Name As you might remember the […]
Optimizing Django Database Queries
Before we move on to the topic, I’d like to apologize for the irregular updates, but I’m going through a few courses that take a lot of time. On the other hand, from time to time they result in inspirations for new posts. One of such a case is a course focused on working with […]