Viewing Issue Advanced Details
[ Jump to Notes ]
[ Wiki ]
|
[ View Simple ]
[ 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 |
Platform |
|
Status |
active |
|
OS |
|
|
OS Version |
|
ETA |
none |
Fixed in Version |
|
Product Version |
5.0.3-B1 |
|
Target Version |
Icebox |
Product Build |
|
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. |
Steps To Reproduce |
|
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 |
|
|