Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-11276

ezsearch - mysql index

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 3.10.0rc1
    • 3.8.8, 3.9.2
    • Database related
    • None

    Description

      When a object is add/change/delete or when you use the updatesearchindex extension the table ezsearch_* are update

      In the plugins file ezsearchengine.php line 417 the query
      "DELETE FROM ezsearch_word WHERE object_count='0'" is faster if we add the index
      ALTER table ezsearch_word ADD KEY `object_count` (`object_count`)

      Attachments

        Activity

          People

            a29ca475-2ac3-469b-95ea-e37ca79eae29@accounts.ibexa.co Sergiy Pushchin
            kouz28 kouz28
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: