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:l...@dhis2.org] Sent: Tuesday, May 31, 2016 4:19 AM To: Abdul karim Jaafar <abdulkarim.jaafa...@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.jaafa...@gmail.com <mailto:abdulkarim.jaafa...@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 <mailto: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 l...@dhis2.org <mailto:l...@dhis2.org> http://www.dhis2.org <https://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