View Issue Details
|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|
|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.|
|Time estimation (hours)||3|