← Back to team overview

dhis2-devs team mailing list archive

Re: Problem creating datamart

 

Hi,

Jason is right, no need to change from mysql. It is also OK to
aggregate a year at the time to reduce memory usage, hopefully you
don't need to do this too often. Can you please:

1. Paste the contents of the Help -> About page from Java opts and below.

2. Paste the number of data values you have in your database from Data
administration -> Data statistics.

It is also a point not to raise the value of Xmx to more than what is
actually available to the JVM, it might trick Java to put more objects
into memory than what is possible, leading to poorer performance/out
of mem errors. So if you have assigned a lot of memory to mysql or
other applications running on the server you might need to lower it a
bit.

Lars


Follow ups

References