|
In-Portal Issue Tracker - In-Portal CMS
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Type: | Reproducibility: | Date Submitted: | Last Update: |
| 665 | [In-Portal CMS] Optimization | task | N/A | 2010-03-27 17:42 | 2011-11-06 15:51 |
|
|
|||||
| Reporter: | alex | Platform: | |||
| Assigned To: | OS: | ||||
| Priority: | normal | OS Version: | |||
| Status: | active | Product Version: | 5.0.3-B1 | ||
| Product Build: | Resolution: | open | |||
| ETA: | none | Fixed in Version: | |||
| Reference: | http://groups.google.com/group/in-portal-bugs/browse_thread/thread/ea65bbfb9b6d670c | ||||
| Change Log Message: | |||||
| Estimate Points: | 2 | ||||
|
|
|||||
| 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: | |||||
| Relationships | |||||
| Attached Files: | |||||
|
|
|||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2011-11-06 15:51 | Dmitry | Target Version | 5.2.0 => Icebox | ||
| 2011-10-22 05:37 | alex | Estimate Points | => 2 | ||
| 2011-09-27 06:22 | alex | Time Estimate Added | 2 | ||
| 2011-09-23 21:49 | Dmitry | Target Version | Icebox => 5.2.0 | ||
| 2010-05-10 14:50 | alex | Target Version | 5.0.4 => Icebox | ||
| 2010-03-27 17:42 | alex | New Issue | |||
| 2010-03-27 17:42 | alex | Reference | => http://groups.google.com/group/in-portal-bugs/browse_thread/thread/ea65bbfb9b6d670c | ||
| There are no notes attached to this issue. |