Dear Abdul Karim
This is quite unusual for this amount of data. We have several million
tracked entity and took only half an hour for run analytics for last three
years.
Can you please check your postgres tuning parameter, server tuning
parameters and get back to me.
Regards
Hannan Khan
On
Hi Lars,
I have 337460 value in data value, 692719 in ‘tracked entity attribute value’
and 994129 in ‘tracked entity data value’
also these inputs are increasing daily,
I have upgraded PostgreSQL to 9.5 but analytic still take much time
now it take about 19 hour!
I use DHIS2
Hi Abdul,
okay. Can you let us know a bit more info here, such as:
- how many data values do you have in your database
- how long does analytics take to complete
- tomcat log output from the process
Upgrading to PostgreSQL 9.5 will make the process significantly faster
compared to 9.3.
Dears all,
I have a problem with analytics period, It take too much time to finish, I
did 'Maintenance' from 'Data Administration' and fixed all problems in 'Data
Integrity'
Sometime when I change tomcat version, analytic goes better.
I want to know what things that make analytic take
An alternative approach will be to use start/end dates for the Options,
similar to the way that Category Options and Org Units do. That way the
Option wouldn't show for data entry, but is preserved for the historical
data.
Rodolfo
On Monday, 30 May 2016, David Siang Fong Oh
5 matches
Mail list logo