Service Packs and Hot Fixes
  1. Service Packs and Hot Fixes
  2. MNT-3438

Improve Alfresco performance by creating an index on the field is_root of the table avm_nodes

    Details

    • Type: Information Information
    • Status: Closed Closed (View Workflow)
    • Priority: Minor Minor
    • Resolution: Not a bug
    • Affects Version/s: 3.2.1
    • Fix Version/s: 4.0.1
    • Component/s: Installer
    • Labels:
      None
    • Environment:
      Tomcat, MySQL, RHEL

      Description

      A customer is proposing the following index to improve database performance .

      CREATE INDEX idx_is_root ON avm_nodes (is_root) USING BTREE;

      The query to benefit from this index is:

      select an.* from avm_child_entries ce right outer join avm_nodes an on an.id = ce.child_id where ce.parent_id is null and an.is_root = 0;

      The query plan for this query is:

      ----------------------------------------------------------------------------------------------------------------------+

      id select_type table type possible_keys key key_len ref rows Extra

      ----------------------------------------------------------------------------------------------------------------------+

      1 SIMPLE an ALL NULL NULL NULL NULL 3 Using where
      1 SIMPLE ce ref fk_avm_ce_child fk_avm_ce_child 8 alfresco310.an.id 1 Using where; Using index; Not exists

      ----------------------------------------------------------------------------------------------------------------------+
      2 rows in set (0.00 sec)

        Activity

        Hide
        dward added a comment -

        is_root = 0 is most nodes!

        Show
        dward added a comment - is_root = 0 is most nodes!
        Hide
        Andrew Hunt added a comment -

        Closing as per Dave's comment

        Show
        Andrew Hunt added a comment - Closing as per Dave's comment

          People

          • Assignee:
            Closed Issues
            Reporter:
            Miguel Rodriguez
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: