L
Leslie
I am tuning and enhancing a database that has imported .csv
data as its main data source (and it will still be
importing this data on a daily basis for the foreseeable
future). I noticed that the previous database developer
had set most of the text fields to 100 - 255 character
lengths. Then I realized that the text data is
automatically set at 255 chars in length when it is
entering an import table (regardless of the actual size of
the data in each field). I would like to reset the field
lengths in the storage tables to something smaller and more
consistent with the actual data sizes.
I am assuming that this might provide some performance
benefit and also to support consistent data entry (some
data is entered by hand)
data as its main data source (and it will still be
importing this data on a daily basis for the foreseeable
future). I noticed that the previous database developer
had set most of the text fields to 100 - 255 character
lengths. Then I realized that the text data is
automatically set at 255 chars in length when it is
entering an import table (regardless of the actual size of
the data in each field). I would like to reset the field
lengths in the storage tables to something smaller and more
consistent with the actual data sizes.
I am assuming that this might provide some performance
benefit and also to support consistent data entry (some
data is entered by hand)