CRM-19350 Add index to civicrm_contact.preferred_language field

          Details

          • Documentation Required?:
            None
          • Funding Source:
            Contributed Code

            Description

            We have a need for an index on the civicrm_contact.preferred_language field.

            I gave some thought as to whether we should add it or add it to core but ended up concluding a good criteria for core is "Is this field exposed for searching" - to which the answer is yes so I'm going to submit a PR for core

              Attachments

                Activity

                [CRM-19350] Add index to civicrm_contact.preferred_language field
                Tim Otten added a comment -

                Seems reasonable/proportionate...

                TBH, I have trouble imagining what use-case would benefit from indexing just preferred_language but accept that it could exist. If we had some way to do discretionary indexing (define a default list of indices... and then let admins tweak them), that might be better, but it's probably not proportionate.

                Eileen McNaughton added a comment -

                change of heart for now

                  People

                  • Assignee:
                    Eileen McNaughton
                    Reporter:
                    Eileen McNaughton

                    Dates

                    • Created:
                      Updated:
                      Resolved: