Project

General

Profile

Actions

Feature proposal #8671

closed

Remove costly user table join

Added by krileon about 3 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
15 August 2021
Due date:
% Done:

100%

Estimated time:

Description

This is being done to check for approved, confirmed, and blocked states. There isn't a need for this. If a user becomes unconfirmed, unapproved, or blocked just listen to that event and unpublish their activity. There's already handling for deleting a users activity. For banned profiles just stop linking the activity to their profile. This will completely eliminate the need to join _users and _comprofiler. If the user no longer exists the activity can show as "Deleted" or "Anonymous" with default avatar.

Actions #1

Updated by krileon about 3 years ago

  • % Done changed from 0 to 30
Actions #2

Updated by krileon about 3 years ago

  • % Done changed from 30 to 80
Actions #3

Updated by krileon about 3 years ago

  • % Done changed from 80 to 90

Just needs event handling for dealing with blocked users (unpublish their content).

Actions #4

Updated by krileon over 1 year ago

  • Status changed from Assigned to Resolved
  • % Done changed from 90 to 100
Actions #5

Updated by krileon about 1 year ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF