Viewing Issue Simple Details
[ Jump to Notes ]
[ Wiki ]
|
[ View Advanced ]
[ 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 |
Fixed in Version |
|
Status |
active |
Product Version |
5.0.1 |
Target Version |
Icebox |
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. |
Additional Information |
|
Tags |
No tags attached. |
|
Reference |
|
Change Log Message |
|
Estimate Points |
0 |
|
Attached Files |
|
|