Skip to:
Content

BuddyPress.org

Changes between Initial Version and Version 1 of Ticket #7500, comment 3


Ignore:
Timestamp:
04/12/2017 08:30:38 PM (5 years ago)
Author:
johnjamesjacoby
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #7500, comment 3

    initial v1  
    55It'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.
    66
    7 Once we've done that, an upgrade routine will need to be introduced that comfortable 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.
     7Once 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.
    88
    99TL;DR - We need: