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:
                  1 year, 41 weeks, 2 days 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