Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-205

Database index not used, when quering phrases by name

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: no change required
    • Affects Version/s: 5.0.0
    • Fix Version/s: 5.0.2
    • Component/s: Optimization
    • Labels:
      None

      Description

      We have index on Phrase column, which is good. Phrases are loaded using this database query:

      SELECT PhraseId, Translation
      FROM Phrase
      WHERE (LanguageId = 1) AND (UPPER(Phrase) = 'lu_SamplePhrase')

      In mentioned above query phrase column value is uppercased and then compared to phrase name to be loaded. In this case, according to MySQL documentation, index is not used.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: