Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1.4
    • Fix Version/s: 2.1.6, 2.2
    • Component/s: None
    • Security Level: All
    • Labels:
      None
    • Environment:
      PHP 5.3.6

      Description

      After upgrading to 2.1.4 (from 2.1.2), the following dql started creating way more queries than necessary :
      SELECT m, p, s, c, o
      FROM FERMainBundle:Menu m
      LEFT JOIN m.page p
      LEFT JOIN m.section s
      LEFT JOIN m.children c
      LEFT JOIN s.position o
      ORDER BY m.lft

      Details to the code here:
      http://pastie.textmate.org/private/z9gtgqe1odwenxcmudywqa
      The model looks like that:
      http://pastie.textmate.org/private/przxzfimsfyua02cxqcv9a

      http://pastie.textmate.org/private/ob1jqiekv89e4xj9bq06q
      First query is executed, it should in fact retrieve everything there is about the menu, but then it runs the second query for every menu element I have, generating a lot of queries that didn't occur before.

      1. trace.txt
        5.94 MB
        Pascal Burkhard
      2. trace.txt
        40 kB
        Pascal Burkhard

        Issue Links

          Activity

          Hide
          Benjamin Eberlei added a comment -

          Fixed

          Show
          Benjamin Eberlei added a comment - Fixed
          Hide
          Benjamin Eberlei added a comment -

          I found the issue.

          Show
          Benjamin Eberlei added a comment - I found the issue.
          Hide
          Pascal Burkhard added a comment -

          Alright. I deactivated the Tree extension, but there are no changes in the number of queries.

          Show
          Pascal Burkhard added a comment - Alright. I deactivated the Tree extension, but there are no changes in the number of queries.
          Hide
          Benjamin Eberlei added a comment -

          Can you disable the nested set extension? the other ticket uses it too and i want to rule out that its the extensions fault.

          Show
          Benjamin Eberlei added a comment - Can you disable the nested set extension? the other ticket uses it too and i want to rule out that its the extensions fault.
          Hide
          Pascal Burkhard added a comment -

          The "complete" trace, i.e. the one that is 5.94 mb big is from after the upgrade to 2.1.5.

          Show
          Pascal Burkhard added a comment - The "complete" trace, i.e. the one that is 5.94 mb big is from after the upgrade to 2.1.5.

            People

            • Assignee:
              Benjamin Eberlei
              Reporter:
              Pascal Burkhard
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: