Analytics period

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,

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@gmail.com 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@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org

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@dhis2.org]
Sent: Tuesday, May 31, 2016 4:19 AM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
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@dhis2.org

http://www.dhis2.org

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 Tue, May 31, 2016 at 10:05 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

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@dhis2.org]
Sent: Tuesday, May 31, 2016 4:19 AM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
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@gmail.com 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@lists.launchpad.net
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@dhis2.org

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Muhammad Abdul Hannan Khan

Secretary

HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118

F +88 02 8813 875

M+88 01819 239 241

M+88 01534 312 066

E hannank@gmail.com

S hannan.khan.dhaka

B hannan-tech.blogspot.com