dhis2-users team mailing list archive

["Abdul karim Jaafar" <abdulkarim.jaafar87@xxxxxxxxx>]

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 Version: 2.22

 

Build revision:22057

Java version:1.8.0_92

 

Time since last analytics table generation:

34 h, 32 m, 5 s

Last analytics table runtime:

18 h, 44 m, 55 s

 

Best regards,

 

 

 

From: Lars Helge Øverland [mailto:lars@xxxxxxxxx] 
Sent: Tuesday, May 31, 2016 4:19 AM
To: Abdul karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx>
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Analytics period

 

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.

 

regards,

 

Lars

 

 

On Mon, May 30, 2016 at 10:56 PM, Abdul karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx <mailto:abdulkarim.jaafar87@xxxxxxxxx> > wrote:

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 much time, and how to make it faster

 

I have server, OS Windows 64 bit, ram 32 GB, hard 2 TB

 

Best regards,

Abdul Karim,


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp





 

-- 

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@xxxxxxxxx <mailto:lars@xxxxxxxxx> 

http://www.dhis2.org <https://www.dhis2.org/>