Excessive memory consumption during execution

Created on 28 July 2025, 2 months ago

When creating a view from a CiviCRM contact, the system automatically includes all contact-related custom tables using LEFT JOINs and adds all associated custom fields to the SELECT clause. This behavior results in high memory usage during query execution.

The actual query executed behind the view can be observed by running:

SHOW FULL PROCESSLIST;

in MySQL.

πŸ› Bug report
Status

Active

Version

4.0

Component

Code

Created by

πŸ‡¬πŸ‡§United Kingdom vakeesan26

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024