Details
-
Improvement
-
Resolution: Unresolved
-
High
-
4.7.0, 5.0, 5.1, 5.2, 5.3.2
-
None
-
None
Description
On an xml content with an amount of links , ezoe will generate "n" select queries and potentially "n" insert queries when storing it's xml content.
This means that the number of SQL queries grows linearly for each attribute,
which may lead to performance issues on "large" content.
Ideally, there should be a single SELECT query, to determine url_object_links to be created.
Ref: https://github.com/ezsystems/ezpublish-legacy/blob/master/extension/ezoe/ezxmltext/handlers/input/ezoexmlinput.php#L530