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 Children
  • Hi Rafa,

    You're right, we didn't use external cache system. 
    I tried to configure APC or memcached or Redis and I didn't find any benefits, do you have any documentation related on configuring Redis or memcached please ? 

    Here is my config.php for redis : 

    'external_cache' =>
      array (
        'memcache' =>
        array (
          'host' => 'localhost',
          'port' => '11211',
        ),
        'redis'  =>
        array (
          'host' => '127.0.0.1',
          'port' => '6379',
        ),
      ),
      'external_cache_disabled' => false,
      'external_cache_disabled_apc' => true,
      'external_cache_disabled_memcache' => true,
      'external_cache_disabled_memcached' => true,
      'external_cache_disabled_redis' => false,
      'external_cache_disabled_smash' => true,
      'external_cache_disabled_wincache' => true,
      'external_cache_disabled_zend' => true,

    What are all the pre-requisites to use redis ? should I install pecl redis ? 

    Thanks in advance for your feedback :-)

    Best regards,

    Enes

  • Hi ,

    I configured redis on our dev server but the OutboundEmail list is still very slow to restitution. Any thing else you can advise ?

    Best regards,

    Enes