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 EstimateNo 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.
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
child of 0000314closed (5.0.1)alex Add Case-Insensitive Field to Phrases table for storing Labels 

-  Notes
User avatar (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.
User avatar (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

Powered by Mantis Bugtracker