Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 5.0
    • Fix Version/s: None
    • Labels:
    • Environment:
      Amazon EC2, Default Alfresco install (PostgreSQL)
    • ACT Numbers:

      00857215

    • Affects:
      Performance

      Description

      Potentially slow query during ACL tracking.

          <select id="select_ChangeSets_Summary" parameterType="SOLRTrackingParameters" resultMap="result_AclChangeSet">
              select
                  acs.id              as id,
                  acs.commit_time_ms  as commit_time_ms,
                  count(acl_id) as acl_count
              from
                  alf_acl_change_set acs
              join alf_access_control_list acl on (acl.acl_change_set = acs.id)
              <where>
                 exists (select 1 from alf_node admnode where admnode.acl_id = acl.id)
                 <if test="fromCommitTimeInclusive != null">
                     and <![CDATA[acs.commit_time_ms >= #{fromCommitTimeInclusive}]]>
                 </if>
                 <if test="fromIdInclusive != null">
                     and <![CDATA[acs.id >= #{fromIdInclusive}]]>
                 </if>
                 <if test="toCommitTimeExclusive != null">
                     and <![CDATA[acs.commit_time_ms < #{toCommitTimeExclusive}]]>
                 </if>
                 <if test="toIdExclusive != null">
                     and <![CDATA[acs.id < #{toIdExclusive}]]>
                 </if>
              </where>
              group by acs.commit_time_ms, acs.id
              order by acs.commit_time_ms ASC, acs.id ASC
          </select>
      

      Query plan needs to be checked.

      To reproduce:

      • Sign up 50K users
      • Execute Share and Workflow load tests for 6H.
      • Profile

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedissues Closed Issues
                  Reporter:
                  mbynum Marc Bynum
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel