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

0 Rafael Fernandes over 2 years ago

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

SugarCRM | Principal Developer Advocate
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Enes Saridogan over 2 years ago in reply to Rafael Fernandes

Hi Rafael Fernandes,

Hardware spec for the production instance :

Clustered installation (two servers for apache), 17Gb RAM each, 8Gb allowed to PHP, php-fpm configured

What I can show you is the New Relic trace :

As you can see the queries are really fast, the function retrieveSettings (for this case only) is causing the slow time.

Thanks a lot for your help,

Best regards.

Enes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Enes Saridogan over 2 years ago in reply to Rafael Fernandes

Hi Rafael Fernandes,

Hardware spec for the production instance :

Clustered installation (two servers for apache), 17Gb RAM each, 8Gb allowed to PHP, php-fpm configured

What I can show you is the New Relic trace :

As you can see the queries are really fast, the function retrieveSettings (for this case only) is causing the slow time.

Thanks a lot for your help,

Best regards.

Enes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data