#3960 - Re-review all indexes

Identifier #3960
Issue type Feature request or suggestion
Title Re-review all indexes
Status Open
Tags

Type: Performance (custom)

Handling member Deleted
Addon core
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.
Steps to reproduce

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.
Related to

#3957 - Support for descending indexes
Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated