ODK Aggregate and Large Database (50gigs)

Support
1

What is the problem?
ODK server is very slow in switching between forms on the server, these forms collect about six photos per submission, the problems comes when the forms are trying to load on login as well as switching views between the different forms on the server

What ODK tool and version are you using ? And on what device and operating system version?
currently running ODK 1.71 and centos 6.3 with mysql 5.7, 32 GIGS of ram and 8 core processor

What steps can we take to reproduce the problem?

What you have you tried to fix the problem?
we have tried adding more ram to the server but that does not help

Anything else we should know or have? If you have a test form or screenshots or logs, attach here.

2

You'll need to do some of your own testing to try to figure out where the problem is because there are a lot of variables. Some questions to answer...

  1. Look at your CPU, RAM, disk IO, etc. Any bottlenecks there that you see?
  2. You have 32 GB of RAM, but how much of that is allocated to Tomcat? What about MySQL?