|
Viewing Issue Simple Details
[ Jump to Notes ]
[ Wiki ]
|
[ View Advanced ]
[ Issue History ]
[ Print ]
|
|
ID |
Category |
Type |
Reproducibility |
Date Submitted |
Last Update |
|
0000665 |
[In-Portal CMS] Optimization |
task |
N/A |
2010-03-27 17:42 |
2011-11-06 15:51 |
|
|
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.3-B1 |
Target Version |
Icebox |
| Time Estimate | 2 hours total (2 hours remaining) | |
|
|
Summary |
0000665: Get rid of multi-column indexes in database |
|
Description |
We should get rid of multi-column indexes in database or at least create individual indexes for these columns.
Also Price field index is missing in product prices table.
ALTER TABLE `inp_ProductsPricing` ADD INDEX ( `Price` ); # not on dev though
Also we could place UNIQUE indexes when appropriate, but not in tables, associated (through unit config) with template, that have "Clone" button on them. Phrase table could be a good start. |
|
Additional Information |
|
| Tags |
No tags attached. |
|
|
Reference |
http://groups.google.com/group/in-portal-bugs/browse_thread/thread/ea65bbfb9b6d670c |
|
Change Log Message |
|
|
Estimate Points |
2 |
|
|
Attached Files |
|
|
|
Relationships [ Relation Graph ]
[ Dependency Graph ]
Relationships 
