|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
361 |
[In-Portal CMS] Optimization |
task |
always |
2009-10-06 14:22 |
2009-10-06 14:22 |
|
|
Reporter:
|
alex |
Platform:
|
|
|
|
Assigned To:
|
|
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
active |
Product Version:
|
5.0.1 |
|
|
Product Build:
|
|
Resolution:
|
open |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
|
|
|
Reference:
|
|
|
Change Log Message:
|
|
|
Estimate Points:
|
0 |
|
|
Summary:
|
0000361: Partially replace "LEFT JOIN" to "JOIN" in database queries |
|
Description:
|
I propose to partially replace "LEFT JOIN" to "JOIN" in database queries where "LEFT JOIN" is no needed, e.g. joined record will always exists. Maybe (have not tested yet) it will improve total sql runtime. |
|
Steps To Reproduce:
|
|
|
Additional Information:
|
|
| Relationships | |
|
Attached Files:
|
|
|
|
Issue History |
|
Date Modified |
Username |
Field |
Change |
|
2009-10-06 14:22 |
alex |
Target Version |
=> Icebox |
|
2009-10-06 14:22 |
alex |
New Issue |
|