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

Optimize number of queries used during contact view/edit/save

    Details

    • Type: New Feature
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.1.2
    • Fix Version/s: 4.3.0
    • Component/s: CiviReport
    • Labels:

      Description

      We need to optimize this path and make it more efficient. A couple of possible ideas:

      1. Reduce number of queries issued by looking at query log

      2. Use memcache to cache queries involving meta data (custom field, option groups/values etc)

      3. Cache the "contact values" between the GET and POST and hence avoid doing the same queries during the POST

      4. Be smart about what is updated in the DB. If something has not changed, dont update. Main question is how hard will this be to detect

      5. Reduce the number of form fields in the edit field

      6. Since edit redirects to view, the perceived slowness of edit is due to: saving + rendering the contact. So improving view queries will improve response time

        Attachments

          Activity

            People

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

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3 days, 6 hours
                3d 6h
                Remaining:
                Time Spent - 6 hours Remaining Estimate - 3 days
                3d
                Logged:
                Time Spent - 6 hours Remaining Estimate - 3 days
                6h