View Issue Details

IDProjectCategoryView StatusLast Update
0003960Composrcorepublic2019-11-19 16:58
ReporterChris GrahamAssigned To 
Status non-assignedResolutionopen 
Product Version 
Fixed in Version 
Summary0003960: Re-review all indexes
DescriptionReview 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 InformationThis 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.
TagsType: Performance
Attach Tags
Time estimation (hours)3
Sponsorship open


related to 0003957 non-assigned Support for descending indexes 


There are no notes attached to this issue.

Issue History

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