Contrib.social

Performance issues: Select on base_table.id

Open on Drupal.org →
Created on 27 September 2018, over 6 years ago
Updated 2 February 2023, over 2 years ago

This is for a Domain Site with:

31 domains
28 languages
148 domain alias

One of the slowest queries - "SELECT base_table.id AS id, base_table.id AS base_table_id FROM domain_path base_table INNER JOIN domain_path domain_path ON domain_path.id = base_table.id WHERE (domain_path.source IN (:db_condition_placeholder_?)) AND (domain_path.domain_id IN (:db_condition_placeholder_?)) AND (domain_path.language IN (:db_condition_placeholder_?))

getting initiated in Drush, in DomainPathProcessor.php

💬 Support request
Status

Needs work

Component

Miscellaneous

Created by

🇮🇳India shyamala

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment over 2 years ago →
    🇮🇳India aneek
  • Comment over 2 years ago →
    DominykasM

    the patch is meant for 8.x-1.1-beta1
    please change the version

  • Comment about 2 years ago →
    🇩🇪Germany spuky

    @nexonOSX patch #6 contains either to much stuff or is missing a class...

    Drupal\domain_path\EventSubscriber\DomainPathAliasSubscriber

    is reported as missing after applying the patch

  • Comment 7 months ago →
    🇺🇸United States bburg Washington D.C.

    The error I get in patch from #6 is:

    In RegisterEventSubscribersPass.php line 33:
                                                                                                                           
  Service "domain_path.subscriber" must implement interface "Symfony\Component\EventDispatcher\EventSubscriberInterface".

    Seems like this was intended to be a part of the patch, but was excluded somehow.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024