We have a fairly large moodle instance , with around 6000 active users each month. Our server configuration is also very high like we have 128 GB RAM, 24 cores CPU etc. However we still suffer performance issues and not mainly due to concurrent users, Our server is not able to handle downloading of builtin Moodle reports that have alot of data in them , (Example bulk downloading users from a particular country etc), Also we face performance issues on other moodle pages.
I have been trying to read about performance recommendations of Moodle from https://docs.moodle.org/28/en/Performance_recommendations however since I am not much of a server guy , I am not sure I understand them completely,
Our apache is configured to use php handler suphp . My reading suggested that this will not let us use opcache , is that true? What is the preffered php handler for running a large moodle instance , we are on cent os 6.7 . Also do we need memcache or is opcache sufficient. I do understand the questions are too generic but I just want to understand few basics.
Any help will be much appreciated