lightweight entry queries without custom fields

demo.twig

// Remember old Field service
{% set fieldService = craft.app.get('fields') %}

// Overwrite the service in the container (it will be called later by the EntryQuery)
{% do craft.app.set('fields', 'modules\\NoFields') %}


// Execute the query
{% set result = craft.entries().all() %}


// Restore the original state
{% do craft.app.set('fields', fieldService) %}

NoFields.php

<?php

namespace modules;

class NoFields extends \craft\services\Fields
{
    public function getAllFields($context = null): array
    {
        return [];
    }
}

This is a hack to avoid bloated results, if you don't need them, e.g. when displaying Structures with Entries that have tons of fields, but you need the title only.

Why bother?

Error 1038 Out of sort memory, consider increasing sort buffer size