0003960: Re-review all indexes - Composr CMS feature tracker

ID	Project	Category	View Status	Date Submitted	Last Update

0003960	Composr	core	public	2019-11-19 16:57	2019-11-19 16:58

Reporter	Chris Graham	Assigned To
Severity	Feature-request
Status	non-assigned	Resolution	open
Product Version
Fixed in Version

Summary	0003960: Re-review all indexes
Description	Review all indexes in the system... 1) Is each necessary? Document why with a code comment. If not, remove (as indexes use disk space and slow writes). 2) Is sorting covered on a single index. For example, ideally an index on a category ID will also have a secondary index column on the timestamp, so it can filter and sort from that index. 3) Are there indexes for combined filtering and sorting for things other than timestamps? For example, maybe you can sort by title.
Additional Information	This is not very high priority. When we have over say 10,000 rows in a single category, having combined indexing becomes very important. This is rare outside the forum, which already has stress-tested invoicing.
Tags	Type: Performance

Time estimation (hours)	3
Sponsorship open

Date Modified	Username	Field	Change
2019-11-19 16:57	Chris Graham	New Issue
2019-11-19 16:57	Chris Graham	Tag Attached: Type: Performance
2019-11-19 16:58	Chris Graham	Relationship added	related to 0003957