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

DFS cluster should not use match by LIKE

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Medium Medium
    • Customer request
    • 4.2.0, 4.3.0, 4.4.0, 4.5.0alpha
    • Legacy > Clustering
    • None

    Description

      This probably applies to the DB cluster as well.

      From customer issue:
      ----------------
      UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
      WHERE name like 'var/storage/images/path/path/filename/424242-1-ger-DE/filename.gif/%' s,j3789716 0.7958115183246073 152000

      This happens when I delete image from the trash. You shouldn't match by like. Our dfs table has nearly 3 Million items.
      ----------------

      Steps to reproduce
      • Perform any "name LIKE" query on a huge DFS database.

      Attachments

        Activity

          People

            e8318ba6-e4ae-477c-9116-36c073bd11a3@accounts.ibexa.co Patrick Allaert
            gl gl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: