Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-8200

Aggregating query during contribution search executed twice and not cacheable

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.4.0, 3.4.1, 4.0.0, 4.0.1
    • Fix Version/s: 3.4.2
    • Component/s: CiviContribute
    • Labels:
      None

      Description

      There's a query that gets executed during contribution search which aggregates the contribution totals/averages/etc gets executed twice. Because of minor variations in the query, the query is not cachable, impacting performance. Perhaps the query should be run either only once, or the queries should be written to be identical so it can be cached.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              awjrichards Arthur Richards
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: