1

I am using oroCRM Community Edition in order to create a custom CRM. I created an entity that has 3 translatable fields (used Gedmo Translatable Bundle). I uploaded a list of 200k rows and it created 600k in the translatable table. Whenever I try to display the rows using the DataGrid Bundle provided by oroCRM, it takes 60 seconds to load 10 rows. Then, when I access the Symfony profiler, I discovered that the query that displayed the 10 rows, took 128ms to execute. Each translation query takes 4600ms.

Attached below is the result of the Symfony profiler.

I am wondering if this is related to the limitations of the community edition of oroCRM and if not, what can I do in this case?

Thank you!

Symfony Profiler Output

Mhamed Ali Ben Mahmoud
  • 27
  • 1
  • common n+1 problem. you should change the grid query to directly join the translation table - so it does not need one additional query for each row. see answers of https://stackoverflow.com/questions/97197/what-is-the-n1-selects-problem-in-orm-object-relational-mapping – Rufinus Jan 31 '22 at 16:13

0 Answers0