Project

General

Profile

Actions

Feature proposal #8671

open

Remove costly user table join

Added by krileon 4 months ago. Updated 3 months ago.

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

90%

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 4 months ago

  • % Done changed from 0 to 30
Actions #2

Updated by krileon 3 months ago

  • % Done changed from 30 to 80
Actions #3

Updated by krileon 3 months ago

  • % Done changed from 80 to 90

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

Actions

Also available in: Atom PDF