Why databases are crying at the night
It’s time to stop treating databases as magic boxes that just do their work and are not worthy of your attention. Inside of databases are mechanisms that can prevent errors in performance. Mikhail will tell about these mechanisms and how to work correctly with RDBMS и NoSQL databases.
Late at night, in server rooms, if you listen carefully, you can hear how databases quietly cry. But why?
We as developers often see databases as magic boxes which work fast and without the expense of resources.
Databases are far from ideal, they are just abstractions of many algorithms that interact with each other and a little understanding of what is happening "under the bonnet" can prevent common performance problems.
In this talk, Mikhail will tell about common mistakes in work with RDBMS and NoSQL databases, how they affect performance, why they happen and how to reduce or prevent their effect.