crm icon indicating copy to clipboard operation
crm copied to clipboard

Published 20 hours ago • verified publisher icon oroinc

SQL Optimization on /contact page ( 240 duplicated queries) on locale fr_FR

Open sadortun opened this issue 4 years ago • 0 comments

Summary
Hi,

It seems there is quite a lot of query duplication on the /contact page when using a language different than english. This takes about 250ms to load the 240 similar queries.

image

Steps to reproduce

  • Set language to French (France)
  • Go to /contacts
  • open the profiler. (The profiler is enabled in PROD env)

Actual Result

Expected Result

Details about your environment

  • OroCRM version: 4.1
  • PHP version: 7.4.5
  • Database mysql

Additional information

sadortun avatar Apr 28 '20 22:04 sadortun