We recently upgraded MySQL from version 5.7 to 8.0.41. Post-upgrade, we have observed a noticeable improvement in overall query performance. However, we are encountering a significant performance issue, specifically when accessing list views in modules…

Context: Our database contains orphaned records (e.g., Tasks, Notes) where the parent_type and parent_id reference deleted parent records. These orphaned records, some over five years old, need cleanup to improve database efficiency. Objective: …