Outbound email list view is very slow

Hi Enes Saridogan,

It shouldn't be an issue our ACLs nor the amount of emails you have.

Could you please provide more details? logs, queries, hardware specs?

rafa

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

Well, it's pretty clear that you're caching is not enabled in this case.

Could you check  these settings ? look for  external_cache  in our guide page.

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 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 Rafael Fernandes,

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