2 ms·
I’ve had contracting gigs bringing down the costs of SQL DBs that cost a million per year. You can usually get costs below 200k fairly easily. - Performance tu
by sjducb 3y ago
I’ve had contracting gigs bringing down the costs of SQL DBs that cost a million per year. You can usually get costs below 200k fairly easily.
- Performance tuning
- Migrate old data out of the DB
- Delete unused indexes
- Improve queries so they return less unnecessary data
The problem is usually one massive table or 2-3 unoptimised queries.
No need to rewrite the application to use NoSQL
With seasonal load in AWS it’s really easy to change the DB instance size manually. No need for auto scaling.