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

Profile search makes too many repeated db queries ...

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.9
    • Fix Version/s: 2.1
    • Component/s: None
    • Labels:
      None

      Description

      a quick glance at mysql query log indicates that we are quite inefficient with regard to db queries in profile search. we need to optimize and cache the results.

      On further investigation it looks like we are building the entire "fields" array to resolve a profile. this is not very smart nor efficient, we should optimize and build field elements on a as needed basis. This seems to be part of a restructuring of profile code and pushing it back to 2.1

        Attachments

          Activity

            People

            • Assignee:
              deepak Deepak Srivastava
              Reporter:
              lobo Donald A. Lobo
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: