|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
246 |
[In-Portal CMS] Optimization |
bug report |
always |
2009-08-26 04:06 |
2009-09-23 12:25 |
|
|
Reporter:
|
alex |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
5.0.0 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.0.2 |
|
|
Reference:
|
|
|
Change Log Message:
|
|
|
Estimate Points:
|
0 |
|
|
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. |
|
Steps To Reproduce:
|
|
|
Additional Information:
|
|
| Relationships | | child of | 0000314 | closed (5.0.1) | alex | Add Case-Insensitive Field to Phrases table for storing Labels |
|
|
Attached Files:
|
|
|
|
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 |
|