System resource exceeded: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 48: | Line 48: | ||
* 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 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) | * all records before 2019-01-01 (incl. Log purge) | ||
** this would create a problem because | ** this would create a problem because [[Query send check centralized is owner]] 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 == | ||