When we have a large amount of data in the database, in particular in ezurl_object_link and ezcontentobject_attributem, the URL Management tab loads slowly

Below is information about the testing database:

• ~36k Entries in ezurl Table
• ~820k Entries in ezurl_object_link
• ~2.7M Entries in ezcontentobject_attribute
• ~50k Entries in ezcontentobject_tree

Steps to reproduce

1. Install Ibexa DXP
2. load a database with lots of entries in the tables above
3. check the tab URL Management

Result
With the above data in the database, the SQL query to the database itself takes about 8 seconds

Expected

Optimize the query/execution of the query so that with larger amounts of data the loading time is acceptable.

Note

SQL query to count URLs: 

SELECT COUNT(DISTINCT url.id) FROM ezurl url INNER JOIN ezurl_object_link u_lnk ON url.id = u_lnk.url_id INNER JOIN ezcontentobject_attribute f_def ON (u_lnk.contentobject_attribute_id = f_def.id) AND (u_lnk.contentobject_attribute_version = f_def.version) INNER JOIN ezcontentobject_tree t ON (t.contentobject_id = f_def.contentobject_id) AND (t.contentobject_version = f_def.version) WHERE t.is_invisible = 0