by eggsurplus

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.

Cancel at any time!
Free Trial

#2231 - Slow Query due to SecuritySuite

Closed General Question created by Grace Christian University 3 years ago

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?

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    3 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:

    Let me know if you have any questions.

  2. eggsurplus member avatar

    eggsurplus Provider Affiliate

    2 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:

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "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