Changes to make Centralized data smaller: Difference between revisions

Line 1:

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~~.

As of 2022-08-10 [[Centralized data.mdb]] 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.

=== [[L_Dxs table]] and [[L_Como table]] ===

=== 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.mdb]].

~~==== Next Steps ====~~

~~{{Todo~~

~~| who = Tina~~

~~| todo_added = 2022-08-10~~

~~| todo_action = 2022-09-01~~

~~| question =~~

* Emailed Pagasa to ask to set up a time to remove these tables from Centralized_data. [[User:Ttenbergen|Ttenbergen]] 16:26, 2022 August 25 (CDT)

}}

==== Log ====

* 2022-08-31: Teams with Pagasa where we removed the [[L_Dxs table]] and [[L_Como table]] from [[Centralized data.mdb]]

* 2022-08-10:

** emailed Pagasa to copy Legacy to local

Line 21:

Line 13:

** Julie copied the [[Legacy_TMS_Data.mdb]] to local where SAS will pull from (08Aug2022 )

=== [[Postal_Code_Master table]] ===

=== Reducing fields and field sizes in the [[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.

There is a [[Postal_Code_Master table]] in [[Centralized data.mdb]]. The table is likely in the correct Access file because Pagasa maintains it and Julie uses it.

==== Log ====

@@ Line 1: / Line 1: @@
-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.
+As of 2022-08-10 [[Centralized data.mdb]] 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.
-=== [[L_Dxs table]] and [[L_Como table]] ===
+=== 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.mdb]].
-==== Next Steps ====
-{{Todo
- | who = Tina
- | todo_added = 2022-08-10
- | todo_action = 2022-09-01
- | question =
-* Emailed Pagasa to ask to set up a time to remove these tables from Centralized_data. [[User:Ttenbergen|Ttenbergen]] 16:26, 2022 August 25 (CDT)
-}}
 ==== Log ====
+* 2022-08-31: Teams with Pagasa where we removed the [[L_Dxs table]] and [[L_Como table]] from [[Centralized data.mdb]]
 * 2022-08-10:
 ** emailed Pagasa to copy Legacy to local
@@ Line 21: / Line 13: @@
 ** Julie copied the  [[Legacy_TMS_Data.mdb]] to local where SAS will pull from (08Aug2022 )
-=== [[Postal_Code_Master table]] ===
+=== Reducing fields and field sizes in the [[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.
+There is a [[Postal_Code_Master table]] in [[Centralized data.mdb]]. The table is likely in the correct Access file because Pagasa maintains it and Julie uses it.
 ==== Log ====