Changes to make Centralized data smaller: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 8: | Line 8: | ||
| who = Tina | | who = Tina | ||
| todo_added = 2022-08-10 | | todo_added = 2022-08-10 | ||
| todo_action = 2022-08- | | todo_action = 2022-08-23 | ||
| question = | | question = | ||
* | * After Pagasa has copoied [[Legacy TMS Data.mdb]] to local, remove tables from Centralized master. Emailed Pagasa, but she is away this week and I am away next week, so will review after that. | ||
}} | }} | ||
Revision as of 13:13, 2022 August 11
As of 2022-08-10 Centralized data.mdb was 1.348GB . This is large and slowly approaching MS Access' 2GB limit. The size also makes it slow to copy down, and even slower to copy up. This page is about attempts to make the file smaller.
L_Dxs table and L_Como table
We can reduce the file size to 0.810GB by moving the legacy tables L_Dxs table and L_Como table to Legacy TMS Data.mdb. These tables are “stale” and no longer change, so we don’t really need to have them in Centralized data.mdb.
Next Steps
|
|
|
Log
- 2022-08-10:
- emailed Pagasa to copy Legacy to local
- updated CFE re-link to these in Legacy_TMS_Data.mdb rather than in Centralized data.mdb
- emailed Julie and confirmed we should do this
- imported L Dxs table and L Como table into Legacy TMS Data.mdb as version 2022-08-10
- Julie copied the Legacy_TMS_Data.mdb to local where SAS will pull from (08Aug2022 )
Postal_Code_Master table
There is a Postal_Code_Master table in Centralized data.mdb. The table is likely in the correct file because Pagasa maintains it and Julie uses it.
Log
- removed "code" fields that duplicate "name" field data, and reduced field sizes as much as possible, which reduced table size from ~89MB to ~70MB.
Related articles
| Related articles: |