Viewing Issue Advanced Details
[ Jump to Notes ]
[ Wiki ]
|
[ View Simple ]
[ Issue History ]
[ Print ]
|
ID |
Category |
Type |
Reproducibility |
Date Submitted |
Last Update |
0000361 |
[In-Portal CMS] Optimization |
task |
always |
2009-10-06 14:22 |
2009-10-06 14:22 |
|
Reporter |
alex |
View Status |
public |
Project Name |
In-Portal CMS |
Assigned To |
|
Developer |
|
Priority |
normal |
Resolution |
open |
Platform |
|
Status |
active |
|
OS |
|
|
OS Version |
|
ETA |
none |
Fixed in Version |
|
Product Version |
5.0.1 |
|
Target Version |
Icebox |
Product Build |
|
Time Estimate | No estimate | |
|
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 |
|
Tags |
No tags attached. |
|
Reference |
|
Change Log Message |
|
Estimate Points |
0 |
|
Attached Files |
|
|