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

Performance issues on price set retrieval

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.15
    • Fix Version/s: 4.7.17
    • Component/s: CiviContribute
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      I have hit a serious performance issue affecting 4.7.15 and, I believe a couple around this.

      The issue is because the price set api is called from the contribution view page.

      The price set api adds data about the price set using the getUsedFor function.

      This function looks for forms that use the price set. If it does not find them then it looks at every line item linked with the price set. For the default price set this could mean hundreds of thousands of lines.

      This was a pre-existing problem with the price-set api/ the code it interacts with exposed by a core change to use it.

        Attachments

          Activity

            People

            • Assignee:
              eileen Eileen McNaughton
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: