What's the significance of dataValue directory under dhis/config/files, can we delete as it's getting huge sizer

[jthomas (Jins Thomas)]

We are having a scenario where dataValue directory is getting huge size. Would it be possible for us to delete temporarly while we figure out the storage expansion?

22G ./dataValue

[Gassim (AL-Gassim Sharaf Addin)]

Hi @jthomas

Great to see you posting again!

I see @diallotafsir52 seems to have posted a post detailing some of the challenges they’ve faced around the dataValue table. I’m guessing it could be similar to the issue you are describing?

Handling Analytics Generation with Large Datavalue Table (115GB) for ICRC – Seeking Advice on Optimizing Refresh Process (DHIS2 2.38.5)

Hello DHIS2 Community, We’re encountering a challenge with the DHIS2 instance we manage for the ICRC, particularly with the analytics generation process. We are currently using DHIS2 version 2.38.5. Our datavalue table has grown quite large (around 115GB), and generating analytics for the last three years can take up to 6 hours. We need to refresh the data for the current year at least twice a day, while keeping the older data from previous years available in the analytics tables without having…

I’d recommend not deleting all the dataValues in your system, is there a way to scale the storage without affecting the current setup?