Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-18364

eZSubtreeNotificationRule::fetchUserList generates very slow Query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 4.4.0
    • Fix Version/s: None
    • Component/s: Notifications
    • Labels:
      None

      Description

      SELECT user_node.node_id,
      user_node.path_string,
      user_tree.contentobject_id
      FROM ezcontentobject_tree user_node,
      ezcontentobject_tree user_tree
      WHERE user_node.node_id IN ( 108, 388, 394, 529, 463, 509, 557, 567, 687, 701, 715, 717, 731, 733, 741, 750, 754, 756, 759, 765, 773, 785, 821, 849, 871, 894, 930, 986, 992, 1012, 1047, 1080, 1082, 1172, 1208, 1217, 1236, 1289, 1300, 1306, 1355, 1362, 1371, 1389, 1450, 1452, 1483, 1534, 1540, 1582, 1587, 1597, 1603, 1643, 1686, 1697, 1703, 1716, 1743, 1771, 1795, 1807, 1810, 1936, 1998, 2004, 2013, 2028, 2036, 2080, 2106, 2132, 2187, 2343, 2478, 2662, 2692, 2710, 2907, 3386, 3459, 3601, 3722, 3734, 3878, 4238, 4427, 4803, 4925, 5109, 5144, 5319, 5388, 5579, 5959, 6218, 6360, 6466, 6755, 6759, 6853, 6970, 7082, 7240, 7367, 7917, 8205, 9056, 10004, 10268, 11103, 11386, 11388, 11884, 13569, 13596, 13815, 14258, 14305, 15554, 15599, 15768, 15826, 16139, 17309, 17576, 19369, 19588, 19765, 20123, 21274, 21432, 21725, 21934, 22220, 23516, 23630, 23691, 24357, 24465, 25093, 26248, 29968, 30241, 30489, 30714, 30715, 31769, 31799, 31923, 32121, 33064, 33068, 33088, 33226, 34113, 34136, 34228, 34239, 34308, 34351, 34614, 35490, 35595, 35753, 35785, 36761, 37745, 39019, 39056, 39109, 39722, 39915, 40205, 41053, 41069, 41417, 42547, 44272, 44285, 44492, 44731, 45845, 52005, 52033, 52168, 52419, 52830, 53531, 53841, 55231, 58937, 59500, 61938, 62703, 62887, 63430, 64039, 64140, 66878, 66932, 67786, 69109, 70028, 71940, 72392, 75698, 77877, 79058, 80126, 81261) AND
      user_node.path_string LIKE concat( user_tree.path_string,'%' )

      I have attached a screenshot from JetProfiler.

        Attachments

          Activity

            People

            Assignee:
            pa@ez.no Patrick Allaert
            Reporter:
            Stephan@xrow.de Stephan Bogansky
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated: