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 ]

ID

Category

Type

Reproducibility

Date Submitted

Last Update

0000246

[In-Portal CMS] Optimization

bug report

always

2009-08-26 04:06

2009-09-23 12:25

Reporter

alex

View Status

public

Project Name

In-Portal CMS

Assigned To

alex

Developer

Priority

normal

Resolution

fixed

Fixed in Version

5.0.2

Status

closed

Product Version

5.0.0

Target Version

5.0.2

Time Estimate

No estimate

Summary

0000246: Database index not used, when quering phrases by name

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.

Additional Information

Tags

No tags attached.

Reference

Change Log Message

Estimate Points

0

Relationships [ Relation Graph ] [ Dependency Graph ]

child of

closed (5.0.1)

Add Case-Insensitive Field to Phrases table for storing Labels

Notes
(0000364) Dmitry (manager) 2009-08-27 12:42	Let's add another field which will store UPPER CASE values as soon Label is added so we can Index using that field.

(0000516) alex (manager) 2009-09-23 12:24	This is no longer and issue, because in 0000314 (Add Case-Insensitive Field to Phrases table for storing Labels) new column PhraseKey (with index) was created and uppercase phrase label is stored there. Column therefore is used to load phrase translation.

Issue History
Date Modified	Username	Field	Change
2009-09-23 12:25	alex	Relationship added	child of 0000314
2009-09-23 12:24	alex	Note Added: 0000516
2009-09-23 12:24	alex	Status	reviewed and tested => closed
2009-09-23 12:24	alex	Resolution	open => fixed
2009-09-23 12:24	alex	Fixed in Version	=> 5.0.2
2009-09-23 12:21	alex	Status	active => reviewed and tested
2009-09-23 12:21	alex	Assigned To	=> alex
2009-08-27 12:42	Dmitry	Note Added: 0000364
2009-08-27 12:42	Dmitry	Target Version	=> 5.0.2
2009-08-26 04:06	alex	New Issue

Web Development by Intechnic

In-Portal Open Source CMS

In-Portal Open Source CMS

Copyright © 2000 - 2009 MantisBT Group