Changes to make Centralized data smaller: Difference between revisions
Ttenbergen (talk | contribs) Created page with "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..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
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]]. | 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 === | ==== Next Steps ==== | ||
{{Todo | {{Todo | ||
| who = Tina | | who = Tina | ||
| Line 24: | Line 24: | ||
Further, we have a [[Postal_Code_Master table]] in there. It’s in Centralized Data only because Pagasa maintains it, so if it was in CFE it would get lost if I make an update to that file. But there is no reason it couldn’t live in a different file, that would just have to be added to the push pull machinery for Pagasa. Removing this table further shrinks the file to 0.721GB | Further, we have a [[Postal_Code_Master table]] in there. It’s in Centralized Data only because Pagasa maintains it, so if it was in CFE it would get lost if I make an update to that file. But there is no reason it couldn’t live in a different file, that would just have to be added to the push pull machinery for Pagasa. Removing this table further shrinks the file to 0.721GB | ||
==== Next Steps === | ==== Next Steps ==== | ||
{{Todo | {{Todo | ||
| who = Tina | | who = Tina | ||
Revision as of 14:32, 2022 August 10
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 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
|
|
Postal_Code_Master table
Further, we have a Postal_Code_Master table in there. It’s in Centralized Data only because Pagasa maintains it, so if it was in CFE it would get lost if I make an update to that file. But there is no reason it couldn’t live in a different file, that would just have to be added to the push pull machinery for Pagasa. Removing this table further shrinks the file to 0.721GB
Next Steps
|
|
|
|
Log
Related articles
| Related articles: |