Actually, thanks for asking this stuff, I just realised I could probably save a lot of space in the search index table if I got rid of the revisions that weren't active.
Every edit of a comment is a revision, all revisions are indexed... but there we are, that's not needed... only those that could be viewed (revisions.is_current = TRUE) need to be in the search_index table.
Actually, thanks for asking this stuff, I just realised I could probably save a lot of space in the search index table if I got rid of the revisions that weren't active.
Every edit of a comment is a revision, all revisions are indexed... but there we are, that's not needed... only those that could be viewed (revisions.is_current = TRUE) need to be in the search_index table.