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

              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