System resource exceeded: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 45: | Line 45: | ||
== Solution approach: Purging some old data from centralized == | == Solution approach: Purging some old data from centralized == | ||
I made a copy and deleted all child records before 2015-01-01 (ie kept L_Log complete, but deleted corresponding records in L_TmpV2 etc). This shrunk centralized from 1GB to 618MB. However, it did '''not''' solve the problem. | I made a copy and deleted records: | ||
* all child records before 2015-01-01 (ie kept L_Log complete, but deleted corresponding records in L_TmpV2 etc). This shrunk centralized from 1GB to 618MB. However, it did '''not''' solve the problem. | |||
* all records before 2019-01-01 (incl. Log purge) | |||
** this would create a problem because we would no longer be able to conclusively check for records that already exist in the db, ie. someone accidentally uses Pat_ID 100 rather than 1000) | |||
== Solution approach: Query size limiting == | == Solution approach: Query size limiting == | ||