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

    XMLWordPrintable

    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

          is related to

          Bug - A problem which impairs or prevents the functions of the product. LPS-56639 Create Indexes for news Columns in DLFileEntry Table

          • Closed

            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