Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-1406

OrgIdentitiesController Unoptimized MySQL (MariaDB) Query

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Done
    • COmanage Registry 2.0.0 (Passing Fad)
    • Registry
    • 5.5.5-10.0.17-MariaDB-log MariaDB Server (Amazon RDS)

    Description

      In OrgIdentitiesController, the combination of

      $view_contains  = array(..., 'PipelineCoPersonRole', ...)
      

      and

      public $paginate = array(
        'order' => array(
          'PrimaryName.family' => 'asc',
          'PrimaryName.given' => 'asc'
        )
      );
      

      causes /registry/org_identities/index/co:x to hang on O(10000) datasets.

      Attachments

        Issue Links

          Activity

            People

              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist