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!

Relationship Graph

[ View Issue ] [ Dependency Graph ]

Viewing Issue Simple Details
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
Assigned To
Priority	normal	Resolution	open
Status	active

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