Change Details

Currently only donors with some form of donation history have segmentation data - this means around 32 million contacts have records & around 8.5 don't - the expectation originally was that the value of adding specific non-donor information to non-donors did not warrant the extra disk usage, back up delay, performance trade offs as we don't do much with them - however, the parent task here has reported it as an issue Just checking with @Dwisehaupt as to how much disk would be taken by increasing the size of the table by 25%

Currently only donors with some form of donation history have segmentation data - this means around 32 million contacts have records & around 8.5 don't - the expectation originally was that the value of adding specific non-donor information to non-donors did not warrant the extra disk usage, back up delay, performance trade offs as we don't do much with them - however, the parent task here has reported it as an issue Just checking with @Dwisehaupt and it would take around 22GB more disk space to store this data (44GB on the staging server which I believe is the one we will run out of disk on first) and add around 1.5 hours to the restore process. Is it possible to simply query for 'OR is empty' in Acoustic @KHaggard ?

Currently only donors with some form of donation history have segmentation data - this means around 32 million contacts have records & around 8.5 don't - the expectation originally was that the value of adding specific non-donor information to non-donors did not warrant the extra disk usage, back up delay, performance trade offs as we don't do much with them - however, the parent task here has reported it as an issue Just checking with @Dwisehaupt as to how much disk would be taken by increasing the size of the table by 25% nd it would take around 22GB more disk space to store this data (44GB on the staging server which I believe is the one we will run out of disk on first) and add around 1.5 hours to the restore process. Is it possible to simply query for 'OR is empty' in Acoustic @KHaggard ?