Installer pv, puis passer de
zcat data-export.gz | mysql -u measuser -p -h db_host -P 3306 mydatabase
à
pv -pret --name ' Importing.. ' data-export.gz | zcat | mysql -u measuser -p -h db_host -P 3306 mydatabase

And that’s the characteristic problem with the normalized approach: In exchange for the simplicity of working exclusively with normalized data, you have to write queries that don’t scale.

With denormalization, there is so much to think about, so much edge cases that needs to be handled !

A reason to use sqlite for small projects.

SQLite is not client/server, however. The SQLite database runs in the same process address space as the application. Queries do not involve message round-trips, only a function call. The latency of a single SQL query is far less in SQLite. Hence, using a large number of queries with SQLite is not the problem.

About the usage of assert, ALWAYS, NEVER, testcase

Différentes astuces pour optimiser la base de données

Un guide PL/SQL. Sous le coude au besoin éventuel

Bien utiliser les indexes des systèmes de gestion de base de données. Plusieurs systèmes sont passées en revue.

Des diagrammes qui sont plus explicites ! J'ai enfin compris les différences entre les JOIN en SQL.