Dear All,
Thanks for the replies.
Upon looking into the matter, due to high usage of system , our system required more hardware specs, so we are now using 32 core intel xeon processor, 128 gb RAM, 2TB hot plug Hard Disk.
While the issue of slow response remained the same, i further investigated the issue, and the reason lied in a slow api request, which was being called upon opening the ‘Data entry’ app. The data from lock exceptions was causing slow response times. The lock exceptions are creating joins with tables, in the api call, thus making response times up to 150 seconds.
So to summarize all of this: We removed the Lock Exceptions in dhis2, and the load timings were smooth.
This issue is handled, while due to heavy data storage, now we are facing another issue, which is described in this link : While running analytics, error occurs No space left on device