View source for Changes to make Centralized data smaller

As of 2022-08-10 [[Centralized_data.accdb]] was 1.348GB . This is large and slowly approaching MS Access' 2GB limit. The size also made it slow to copy down, and even slower to copy up. We made some changes to reduce the size by [[#Removing the L_Dxs table and L_Como table]] and [[#Reducing fields and field sizes in the Postal_Code_Master table]]. This initiative is now complete. 

=== Removing the [[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.accdb]]. 

==== Log ====
* 2022-08-31: Teams with Pagasa where we removed the [[L_Dxs table]] and [[L_Como table]] from [[Centralized_data.accdb]]
* 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.accdb]] 
** 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 )

=== Reducing fields and field sizes in the [[Postal_Code_Master table]] ===
There is a [[Postal_Code_Master table]] in [[Centralized_data.accdb]]. The table is likely in the correct Access 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}}

[[Category:Data Sources]]