Doctrine 1
  1. Doctrine 1
  2. DC-239

Doctrine_Query::getCountQuery() produces subquery if the query contains joins

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0-ALPHA1, 1.2.0-ALPHA2, 1.2.0-ALPHA3, 1.2.0-BETA1, 1.2.0-BETA2, 1.2.0-BETA3
    • Fix Version/s: 1.2.0-RC1
    • Component/s: Query
    • Labels:
      None

      Description

      Is there a reason why Doctrine_Query::getCountQuery() produces subquery only if there is joins or having clause.

      Its not good for high performance environment like ours: it makes the temp file disk full and could kill the server performance.

      Let's the developer the freedom to decide what the count method should return: I prefer it as option like that:

      public function count($withSubquery = false)

      { ... }

      But I want to know the reason why subquery.

        Activity

        Hide
        Jonathan H. Wage added a comment -

        This is fixed in Doctrine 1.2.

        Show
        Jonathan H. Wage added a comment - This is fixed in Doctrine 1.2.

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Fabian Spillner
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: