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!

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ]

[ View Advanced ] [ Issue History ] [ Print ]

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

Project Name

In-Portal CMS

Assigned To

alex

Developer

Priority

normal

Resolution

fixed

Fixed in Version

5.0.0

Status

closed

Product Version

4.3.9

Target Version

5.0.0

Time Estimate

No estimate

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

Tags

No tags attached.

Reference

Change Log Message

Estimate Points

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0000135) alex (manager) 2009-07-19 05:49	Fix committed to RC branch. Commit Message: Fixes 0000117: Extra SQLs for Locale Selection

(0000662) administrator (administrator) 2009-10-03 07:56	Closing issues from 5.0.0 version, because version was already released.

Related Changesets
In-Portal CMS: RC r11913 Timestamp: 2009-07-19 05:49:16 Author: alex [ Details ] [ Diff ]	Fixes 0000117: Extra SQLs for Locale Selection
	mod - /in-portal/branches/RC/core/kernel/db/db_tag_processor.php	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2009-10-03 07:56	administrator	Note Added: 0000662
2009-10-03 07:56	administrator	Status	resolved => closed
2009-07-19 05:49	alex	version	=> 4.3.9
2009-07-19 05:49	alex	Fixed in Version	=> 5.0.0
2009-07-19 05:49	alex	Note Added: 0000135
2009-07-19 05:49	alex	Status	reviewed and tested => resolved
2009-07-19 05:49	alex	Resolution	open => fixed
2009-07-19 05:49	alex	Changeset attached	RC r11913
2009-07-17 20:45	Dmitry	New Issue
2009-07-17 20:45	Dmitry	Status	active => reviewed and tested
2009-07-17 20:45	Dmitry	Assigned To	=> alex

Web Development by Intechnic

In-Portal Open Source CMS