Huge Term Queries

Hi @arypneta,

Thanks for bringing this to our attention!

We’ve investigated and identified the issue. The query is triggered when loading the block editor — our plugin preloads all available tags there, and with 6,000+ tags that results in an oversized query.

We’ll be optimizing this in a future update so tags are loaded on demand rather than all at once.

In the meantime, you can work around it by creating a file called ssp-limit-tags.php in your wp-content/mu-plugins/ directory (create the mu-plugins folder if it doesn’t exist):

<?php
function ssp_get_tags( $hide_empty = false ) {
    $cache_key   = 'ssp_tags';
    $cache_group = 'ssp';
    $tags        = wp_cache_get( $cache_key, $cache_group );

    if ( $tags ) {
        return $tags;
    }

    $tags = get_terms(
        'post_tag',
        array(
            'post_type'  => ssp_post_types(),
            'hide_empty' => $hide_empty,
            'number'     => 100,
            'orderby'    => 'count',
            'order'      => 'DESC',
        )
    );

    wp_cache_set( $cache_key, $tags, $cache_group, MINUTE_IN_SECONDS );

    return is_array( $tags ) ? $tags : array();
}

Please let us know if you have any questions and if it works for you.