umair mohsin

umair mohsin

  • 2k
  • 253
  • 45.9k

How to omit constant values from database tables to reduce db size

Oct 18 2022 9:13 PM

i  have some tablesi n my database with few values which would change after a long time like city, state, duty shifts etc. these values are almost constants and could be change if a company is operative in a state or city which is not listed.

i want to reduce my db size smartly to omit these can i do this.

if for an instance

state has 20 to 30 values 

city has same or more values for a given state

how may i do this do reduce load from my database    

Answers (5)