Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-77891

Remove LOWER Function from Queries Executed in Non Case Sensitive Databases

    Details

      Description

      Using the LOWER function in queries can decrease performance of their transactions.
      Although some databases can be configured as "case insensitive" thus not needing the LOWER function, Liferay still uses the LOWER function in its queries to guarantee the expected result.
      The goal of this ticket is to apply the removal of LOWER functions in queries before they are sent to the database, only if this database is configured to not support case sensitiveness.

      This is already implemented in Liferay for MySQL, so a improvement of performance will only be noticeable when using other databases.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sharry.shi Sharry Shi
              Reporter:
              rodrigo.paulino Rodrigo Paulino
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 35 weeks ago

                  Packages

                  Version Package
                  6.2.X EE
                  7.0.0 DXP FP40
                  7.0.0 DXP SP7
                  7.0.5 CE GA6
                  7.0.X
                  7.1.X
                  Master