hmxDavid wrote:Same here, we are experiencing sluggish performance of our PM 2.8. When I try to look at the problem, I have noticed that the PM has a lot of MySQL queries for counting number of cases in Inbox, Draft, Unassigned, etc. No changes in the config etc.
The case lists in the Community Edition slow down a lot when there are a large number of cases in the database.
The database in the Enterprise Edition has been optimized so that case lists will load faster without having to count the number of cases every time.
Switching to the Enterprise Edition will improve performance. If you don't want to do that, you can add RAM, upgrade to a faster CPU or move the database to a separate server, but check how your server is using resources first to see if that makes sense. The other solution is to delete old cases from the database. (The Enterprise Edition has a case archiver for that purpose.)
Amos B. Batto ♦ ProcessMaker Forum Manager since 2009