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

Improving Database performance on custom fields

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      Currently, the system supports two types of custom fields: Radio Buttons for yes/no, which create tinyint boolean fields and all others, which are varchar(255). MySQL is significantly more efficient in searching integer fields and it is wasteful to use 255 bytes for something that is really a single character field. When defining custom fields, it would be desireable if it were possible to define that they are expected to be numeric and to also be able to define the length.

        Attachments

          Activity

            People

            • Assignee:
              sushant Sushant Paste
              Reporter:
              nmiracle Nancy Miracle
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: