[prasadmani]

Hi,

We are facing Performance issue with Bitnami Processmaker community edition 3.1, kindly let us know the changes required in the process maker configuration to improve the performance.

It takes time to load home page after logging in.

Server Configuration:

Server : Windows server 2012 R2
System Type : 64 bit
System RAM : 8 GB
Processor : Intel Xeon E312xx 2.20 GHz

[amosbatto]

How much time does it take to load your http://domain/sysworkspace/en/neoclassic/cases/main page?
Roughly how many concurrent users do you have (i.e. how many users logged in at the same time)? How many records do you have in your wf_workspace.APPLICATION table?

Generally it is not recommended to use Bitnami installations for production. Do a manual installation and generally Linux is recommended over Windows if you have a large number of users. PHP 5.6 is faster than PHP 5.5, since it has opcache included. PHP 5.7 is reportedly twice as fast, but PM isn't yet compatible with PHP 5.7.

The Enterprise Edition has been optimized to generate the case lists faster for users, so it doesn't have to recalculate how many cases are in To Do, Draft, Participated, etc. everytime the user goes to the Home menu.

You can install MySQL on a separate server if you have a large scale deployment.

[prasadmani]

Hi SOD,

There are around 80 to 100 concurrent users in the system.

Could you please let us know the steps to tune Apache Web server and MySQL database configuration/settings for improving performance of the application . Please note that we have configured the MySQL in separate server still see high level of CPU usage for just 25 concurrent users.

[amosbatto]

There are around 80 to 100 concurrent users in the system.

Could you please let us know the steps to tune Apache Web server and MySQL database configuration/settings for improving performance of the application . Please note that we have configured the MySQL in separate server still see high level of CPU usage for just 25 concurrent users.

PM uses a lot of resources. You need to install PM in a server with more processing cores in the CPU or a dual CPU server.

Another option is to set up a reverse proxy in Apache that redirects the traffic to multiple servers where PM is installed. See: http://iws.io/multiple-web-servers-over ... rse-proxy/
All the installations should use the same MySQL database on another server and PM's shared directory should be placed on a NAS (network access storage).

If your organization can't run these kinds of servers, you should contact ProcessMaker Sales and ask about our hosting services. We also help you do a reverse proxy installation on your own servers.

[ravimallya]

Thank you amosbatto.

Could you please let us know if any Apache modules we can disable to improve the performance or any Apache MPM setting changes required to improve the CPU utilization.

[amosbatto]

If you have this line in your virtualhost definition in the pmos.conf file in Apache, your server will do a bit more processing, but it saves on the amount of network traffic:

Code: Select all

          #Deflate filter is optional. It reduces download size, but adds slightly more CPU processing: 
          AddOutputFilterByType DEFLATE text/html

If you have PHP 5.5 or later installed, then you automatically have opcode installed, so I don't think there is anything else you can do to speed up PHP.