Uploaded image for project: 'PUBLIC - Liferay Portal Enterprise Edition'
  1. PUBLIC - Liferay Portal Enterprise Edition
  2. LPE-15061

Slow performance with DLFileEntry table queries due to lack of index columns

    Details

      Description

      Some SELECT queries to the DLFileEntry table in the database are slow, especially using data that may have been added after upgrading from older versions of Liferay.

      This issue is resolved in this fix by adding new columns to the DLFileEntry table as indexes.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alec.shay Alec Shay
                Reporter:
                laszlo.hudak Laszlo Hudak
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  6.2.X EE