Outbound email list view is very slow

Hi sugar lovers,

I'm facing an annoying behaviour in our customer's instance, as the list of the configured Outbound Emails is very very slow to display, at least 1 minute for the quickest ...

We have only 9 emails that are configured, so this couldn't be the problem. The instance has 160.000 emails in the table email_addresses.

We are running on Sugar V10.0.4 ENT, Oracle 19c Database.

Did anyone get this behaviour too ?

New Relic is showing a cascade of calls to retrieve ACL Access Rights.

Thanks a lot for your feedbacks.

Best regards,

Enes

Parents Reply
  • Hi again Rafa,

    After getting deeper into the code, within the function "retrieveSettings", when I comment the following piece of code (if $clean) there is no slowdown ... what I can see is that the cache regeneration is causing that.

    // declare a cache for all settings
    $settings_cache = sugar_cache_retrieve('admin_settings_cache');
    
    // if($clean) {
    //     $settings_cache = array();
    // }

    Any clue ? Should I clean something or improve other thing ?

    Best regards,

    Enes

Children