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

Laravel Maintenance Mode with Spatie’s multi tenancy package

Altering Drupal 8+ content view to hide content types for user roles

Video transcoding and optimization for web with ffmpeg made easy

Way to MLH Fellowship 👩🏼‍💻

Your Runbooks Need Some Love

READ/DOWNLOAD%+ Mastering Cloud Computing: Foundat

Texas Holdem Poker Odds Table

Holdem

Jenkins Installation

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

Run Automated Tests in Pipeline

Running sqlite on the browser

Strategy Design Pattern

How well does your API perform?