Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#2231 - Slow Query due to SecuritySuite
Users are experience very slow queries and filters. The slow performance occurs with all users other than Administrators. We noticed a second query is being run by SecuritySuite. What can be done to improve performance?
-
"The add-on itself was already a must for my SuiteCRM, which was missing this very important security feature. However, what surprised me the most was ..." - Davint
Read More Reviews
Larry Rudd
5 years ago
Sounds like it is time to do some optimizing on your instance. Here are some tips to help make it run fast again: https://store.suitecrm.com/docs/securitysuite/optimizing-securitysuite.
Let me know if you have any questions.
5 years ago
A new 3.1.18 version has just been released that adds an option to use a different query method. By default it will use the "IN" query method. Some database versions do better with "EXISTS", but that is no longer the default. However, that can be enabled if desired. More info available in the release notes: https://store.suitecrm.com/docs/securitysuite/release-notes