Optimize your database

Image Source

Optimize queries

Add indexes

Update statistics

Reorganize indexes

Remove constraints

Remove foreign keys

Image Source

Denormalize tables

  • You should manually handle consistency of data in different table and use transactions for it
  • That brings overhead on inserting data and makes queries be slower
  • That requires more space on the disk

Distributes data among servers

Split database by services

Improve the hardware for database

Image Source

In conclusion

--

--

--

🚀 Marvelous Senior Backend Software Developer 📚 Like to share my knowledge 🎤 Beginner Public Speaker 🏠💻 Live and work in London https://github.com/oleg-sta

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Project Data Analysis for B2B Retail : Customer Analytics Report

The Top 1 Popular Software Package Wins a 40K+ Downloads-AT Device

Day 5: Nice Sprites

My Journey with JSON

Unity Dev: Multiple Action Maps (New Input System)

Docker Diaries: Pinning-by-digest

Weekly Update: W/C 02nd September, 2019

SLA and SLO fundamentals and how to calculate SLA

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Oleg Stadnichenko

Oleg Stadnichenko

🚀 Marvelous Senior Backend Software Developer 📚 Like to share my knowledge 🎤 Beginner Public Speaker 🏠💻 Live and work in London https://github.com/oleg-sta

More from Medium

How to outsource your Devcontainer configuration

Database and Information Systems Development: Data Dictionaries

How to Get the Attribute Names of a Database Table?

Use MySQL to Generate MySQL for Admin Tasks