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

Extra SQLs for Locale Selection

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.3.9
    • Fix Version/s: 5.0.0
    • Component/s: Database
    • Labels:
      None

      Description

      Noticed extra SQLs for Locale Selection. We need to optimize to 1 instead of 4 please see below:

      Name:
      SELECT Locale
      FROM Language
      WHERE LanguageId = 1
      LIMIT 0,1
      [Runtime: 0.00059199333190918s] File: db_tag_processor.php:2133 [Affected Rows: 1] [Result: en-US] [Query Number: 34]
      Name:
      SELECT Locale
      FROM Language
      WHERE LanguageId = 1
      LIMIT 0,1
      [Runtime: 0.00062298774719238s] File: db_tag_processor.php:2134 [Affected Rows: 1] [Result: en-US] [Query Number: 35]
      Name:
      SELECT Locale
      FROM Language
      WHERE LanguageId = 1
      LIMIT 0,1
      [Runtime: 0.00061297416687012s] File: db_tag_processor.php:2133 [Affected Rows: 1] [Result: en-US] [Query Number: 36]
      Name:
      SELECT Locale
      FROM Language
      WHERE LanguageId = 1
      LIMIT 0,1
      [Runtime: 0.00057888031005859s] File: db_tag_processor.php:2134 [Affected Rows: 1] [Result: en-US] [Query Number: 37]

        Attachments

          Activity

            People

            • Assignee:
              alex Alex
              Reporter:
              dmitry Dmitry Andrejev [Intechnic]
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: