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

umair mohsin

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 tables.how 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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

umair mohsin3y ago
Dear sam thank you for your reply.i hope i have clearly expain my issue what i am facing so what you suggest me to do.

I want to improve my self for future work as this is a small application but in the future i may be develop application for bigger organization

I was thinking if there is a way to reduce load/reduce space

Please guide me accordingly
Sam Hobbs3y ago
If you put the data in the application then the data will take up space in the application. If I understand what you are saying then it will not improve resources for the the computer or make it faster but it would make extra work for developers. Data in a database can be maintained by the user but data in the application must be maintained by the developer.
umair mohsin3y ago
I was working on a portal where user selects where he /she lives(city,state)seperately.what the education,career level ,experience,preferred working shift etc

All these values are constants and change after long time or may not change but these values taking extra space in db in the form of seperate tables.

Is there any way to let these values be apart of my application but no of db.

If needed i will fetch records from other tables based on these values.but putting them in tables is memory taking.i want to reduce this effect for my table.please help me accordingly
rajesh nandwani3y ago
One way of doing would be to create tables state, city with identity fields of tinyint type and add reference fields of the same type in tables which have city and state. If there are several tables then the size would reduce.
Sam Hobbs3y ago
Please tell us more about what you data is like currently.

Are the city and state and other values in every record? If so then you can create a table for each state and for each city and such. Then you can have a primary key for each table. For the USA the primary key fore the states can be the two-letter code used by the United States Postal Service, such as CA for California and NY for New York. The city table should have a foreign key for the state. Is that the type of thing you are asking about?