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.

Free 30 day trial
Try it Now

#2231 - Slow Query due to SecuritySuite

Closed General Question created by Grace Christian University a year 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

    a year 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

    a year 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...
  • "Thank you so much. Highly recommend the module to work in teams."

    Read More Reviews