Performance hit on user based filters

Added by Taner Tas over 3 years ago

We are experiencing performance issues when using user based filters. A simple "Assigned to = << me >>" filter takes about 60 seconds to complete. We have 8K LDAP users registered.

Is there a performance spot regarding number of registered users? This issue happens even when there is no resource usage at all.

Redmine 4.0.x
Rails 5.2.x
PostgreSQL backend