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

Optimize CiviCRM search and what we store in the cache table DB

    Details

    • Type: New Feature
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.0
    • Labels:
      None

      Description

      Currently contact search stores an incredibly long serialized array (on sample data a search stores approx 200K in the cache table). A lot of these are redundant links (introduced with the contextual menu). We should optimize this to store only whats needed

      We store things in the cache table to avoid redoing the query and we should continue doing so

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours
                4h