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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: