Details

      Description

      Datatype keyword generates sql request like this one.

      SELECT ezkeyword.keyword
      FROM ezkeyword_attribute_link, ezkeyword
      WHERE ezkeyword_attribute_link.keyword_id = ezkeyword.id
      AND ezkeyword_attribute_link.objectattribute_id = "my_id"

      Without index on "objectattribute_id" and with a lot of data, this request can be very slow.
      When doing an EXPLAIN, you can see that without index, mysql fetch all the content of the keyword table.

      Adding an index on objectattribute_id increases performance.

        Issue Links

          Activity

          Hide
          (inactive) Gunnstein Lye added a comment -

          Fixed in
          trunk (4.2.0Alpha1) rev. 23703
          stable/4.1 (4.1.4) rev. 23704
          stable/4.0 (4.0.7) rev. 23705

          Show
          (inactive) Gunnstein Lye added a comment - Fixed in trunk (4.2.0Alpha1) rev. 23703 stable/4.1 (4.1.4) rev. 23704 stable/4.0 (4.0.7) rev. 23705
          Hide
          (inactive) Gunnstein Lye added a comment - - edited

          Gaetano: We need the same index on Oracle too.

          Show
          (inactive) Gunnstein Lye added a comment - - edited Gaetano: We need the same index on Oracle too.
          Hide
          Gaetano Giunta added a comment - - edited

          Fixed in eZOracle stable/1.8 (1.8.3) rev. 272
          Fixed in eZOracle trunk/2.0 (2.0.1) rev. 273

          Show
          Gaetano Giunta added a comment - - edited Fixed in eZOracle stable/1.8 (1.8.3) rev. 272 Fixed in eZOracle trunk/2.0 (2.0.1) rev. 273
          Hide
          (inactive) Gunnstein Lye added a comment -

          Need to update schema definition too.

          Show
          (inactive) Gunnstein Lye added a comment - Need to update schema definition too.
          Hide
          (inactive) Gunnstein Lye added a comment -

          Fixed in
          trunk (4.2.0Alpha1) rev. 23716
          stable/4.1 (4.1.4) rev. 23717
          stable/4.0 (4.0.7) rev. 23718

          Show
          (inactive) Gunnstein Lye added a comment - Fixed in trunk (4.2.0Alpha1) rev. 23716 stable/4.1 (4.1.4) rev. 23717 stable/4.0 (4.0.7) rev. 23718
          Hide
          ezrobot added a comment -

          This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          Show
          ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

            People

            • Assignee:
              (inactive) Gunnstein Lye
              Reporter:
              (inactive) Gunnstein Lye
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: