3 ms·
Redesign and fix your database. 9 times out of 10 it's poorly designed DB and queries. 145GB means nothing How many rows? Can you partition? Can you use s
by segmondy 8y ago
Redesign and fix your database. 9 times out of 10 it's poorly designed DB and queries. 145GB means nothing How many rows? Can you partition? Can you use smaller datatypes? Are you read heavy or write heavy? Are your indexes designed accordingly? Have you split your DB into OLTP and OLTA DBs? Do you have lots of triggers? Are you having the database doing lots of work which you can outsource to the CPU? Did you actually tune your DB parameters? Is the hardware scaled out max vertically? 145Gb is nothing.