Recommend books on SQL, Python optimization for high loads?

Question

Python

Advise books on optimizing sql queries for high loads, as well as python code. Thank you!

Answer 1

High Performance MySQL Second Edition

Answer 2

The most optimal SQL query: no SQL query.

Answer 3

PythonSpeed/PerformanceTips

Answer 4

Book: PostgreSQL 9.0 High Performance
Very sensible, worth reading, even if you do not have PostgreSQL, because, firstly, there is a lot of useful information about the iron part, and secondly, many things make sense for other DBMS, taking into account their specifics , certainly.
By itself, the Python code, kmk, makes sense to optimize after the libraries for bottlenecks are correctly selected, that is, if there is a large network load, then twisted / tornado, if there are a lot of calculations - numpy / scipy, and so on.
And after the optimal data processing algorithms are selected.

Answer 5

The architecture is optimized for high loads, and the code and base are a secondary matter. Often even the opposite rule applies - with identical functionality of two architectures, one works slower at a small load, but faster at a large one, and, most importantly, holds a large load.
In general, I would advise you to read highscalability.com/