dhis2-users team mailing list archive

[Hannan Khan <hannank@xxxxxxxxx>]

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@xxxxxxxxx> 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@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> 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
> 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
>
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxx
S hannan.khan.dhaka
B hannan-tech.blogspot.com