Changes between Initial Version and Version 1 of Ticket #7500, comment 3
- Timestamp:
- 04/12/2017 08:30:38 PM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #7500, comment 3
initial v1 5 5 It's generally true that indexes on columns with low cardinality is ineffective, however, benchmarks to confirm that full table scans are currently a problem would be useful. That way we can also confirm removing those indexes will improve performance as anticipated. 6 6 7 Once we've done that, an upgrade routine will need to be introduced that comfortabl elocks those tables while the indexes are adjusted. Since the Activity table is highly likely to have many, many rows, even index removal is not a simple or painless process.7 Once we've done that, an upgrade routine will need to be introduced that comfortably locks those tables while the indexes are adjusted. Since the Activity table is highly likely to have many, many rows, even index removal is not a simple or painless process. 8 8 9 9 TL;DR - We need: