dhis2-devs team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Neeraj,

what usually helps to improve runtime is:

- ssd ()
- number of CPUs
-




On Wed, Oct 19, 2016 at 7:13 AM, Neeraj Gupta <neeraj.hisp@xxxxxxxxx> wrote:

> Dear team,
>
> In one of the Indian state we are using DHIS 2.23 and the database size is
> going around 100 GB and once we run analytic it reaches to 500 GB and
> analytic is taking around 25 hours to complete. We are using Postgres 9.4.
>
> Has anyone experienced the situation with 100 GB database or more?
> How did you deal with the time of analytic, Is there any way so that the
> time of analytic can be reduced?
>
> --
> Thanks,
> Neeraj Gupta
>
> _______________________________________________
> 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/>