In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

Dependency Graph [ View Issue ] [ Relation Graph ] [ Vertical ]
related to child of duplicate of

Viewing Issue Simple Details
ID Category Type Reproducibility Date Submitted Last Update
0000117 [In-Portal CMS] Database bug report always 2009-07-17 20:45 2009-10-03 07:56
Reporter Dmitry View Status public  
Assigned To alex
Priority normal Resolution fixed  
Status closed      
Summary 0000117: Extra SQLs for Locale Selection
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]
Additional Information

Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker