3 ms·
Try old school tricks first: - Explain your queries: you will be surprised to know a lot if stuff madre with ORMs is not well indexed. - Take a look at the sl
by eb0la 8y ago
Try old school tricks first:
- Explain your queries: you will be surprised to know a lot if stuff madre with ORMs is not well indexed.
- Take a look at the slow query log (and run that queries with Explain before).
- Exploit recency: I bet most reads are from recent data.. Or data that was written near other data you ask... If that is the case xonsidera partitioning the tables.
- Thing about the best index type form your tables. Some are better than others.
- If some data is not going to be written again, a columnar data store would help...
Don't go distributed at first.
Disributed means when something fails you have to know what abd where is failing... Instead of knowing just what.
If you want to go distributed.. Try sharding right now.
If it works for you, add a cache and use the shards.
But try old school, boring stuff first because you might need it later.
- iKSv2 8y agoWill check what me/team can do on old school lines. Thanks