large database file size

[Guest]

I have added a table to my database that is causing the database size to grow
tremendously. There are a total of 807,000 records of zip codes along with
corresponding latitude, longitude, city and state names.

I have set Unicode Compression to YES by all text fields and have compacted
the database. What other settings or actions will help reduce database file
size?

 

[Guest]

Susan,

I believe is a matter of normalization. For example cities and states
should be kept in separate tables, perhaps using a code (number) for each
one, which will be related to your zip codes table using those numbers and
not text.

GeorgeCY

Ο χÏήστης "Susan" έγγÏαψε: