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
          • Component/s: CiviCRM Search, Core CiviCRM
          • 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

                [CRM-9171] Optimize CiviCRM search and what we store in the cache table DB
                Donald A. Lobo added a comment -


                Committed the first set of patches for this. For the sample data, reduced the size of the serialized array stored to approx 33K from 200K. Will take a look and see if we can reduce this even more

                  People

                  • Assignee:
                    Donald A. Lobo
                    Reporter:
                    Donald A. Lobo

                    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