4

10 Ways to Optimize Your Database

 3 years ago
source link: https://hackernoon.com/10-ways-to-optimize-your-database-zz2q3753
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

2. Add Indexes

If optimization doesn’t help you, then you could think about adding additional indexes.

0 reactions

Of course, you can’t just add any indexes, it doesn’t work that way! So, you should do it wisely:

0 reactions
Firstly, remember that simply 'reading' data (that has indexes) will be faster, but actually changing data by deleting/upserting will be slower.Secondly, indexes require additional space on your disk. As a rule of thumb, indexes could require almost 30–50 % of data volume!

You should check in the documentation of the databases which type of indexes it supports and if they align with your problem.

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK