I am running ScadaBR on windows gathering quite a lot data in it.
The problem is that files in seg0 folder are getting really huge. Whole folder has size approx 16GB.
I tried to investigate the issue and this is what I found.
I ran following queries:
CREATE FUNCTION bigintToHexString(hexString bigint) RETURNS VARCHAR(16) PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME 'java.lang.Long.toHexString';
This created function to check name of files attached to tables.
It seems that the heaviest files in seg0 folder are POINVALUES related files.
c1e11.dat file is 7GB
c1e21.dat is 5 GB
c1df1.dat is 3 GB
I am keeping datapoints from 2 weeks only. I confirmed that and checked in ScadaBR SQL and when I select first and last datapoints they are indeed from this period of time.
It there any way of reducing the size of DB without purging data?
Is it possible that DATAPOINTS tables are so heavy?
Is there any mechanism which creates those heavy .dat files which I don’t understand?