In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

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 Estimate2 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

- Relationships Relation Graph ] Dependency Graph ]

There are no notes attached to this issue.

- 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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker