Problema de performance no DB

  • diegpl

    (@diegpl)


    1 year, 6 months ago

    Olá, vejo que essa linha nova no código, em woo-pagarme-payments.php está puxando muitas linhas no db, atrapalhando a performance:

    $billingFields = WC()->checkout->get_checkout_fields()['billing'];

    Assim como essa, já antiga de versões anteriores ainda não otimizada:

    (new Woocommerce\Pagarme\DB\Migration\Migrator)->execute();

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter diegpl

    (@diegpl)

    1 year, 6 months ago

    Talvez isso funcione para o $billingFields:

    static $cachedFields = null;

    if (is_null($cachedFields)) {
    $cachedFields = WC()->countries->get_address_fields(WC()->countries->get_base_country());
    }

    $billingFields = $cachedFields;

    O outro código, acho que é coisa já antiga que talvez já possa até ser removido, mas com certeza otimizado, está pesando muito o carregamento. Obrigado! 😉

    • This reply was modified 1 year, 6 months ago by diegpl.
    Thread Starter diegpl

    (@diegpl)

    1 year, 5 months ago

    Outra questão que vejo é que este código está carregando tabelas desnecessariamente em todas as páginas do admin, também pesando a performance em lojas mais robustas:

    1. Woocommerce\P\C\WoocommerceDatabaseDecorator->doFetch()
      wp-content/plugins/pagarme-payments-for-woocommerce/src/Concrete/WoocommerceDatabaseDecorator.php:85
    2. Pagarme\C\K\A\AbstractDatabaseDecorator->fetch()
      wp-content/plugins/pagarme-payments-for-woocommerce/vendor/pagarme/ecommerce-module-core/src/Kernel/Abstractions/AbstractDatabaseDecorator.php:39
    3. Pagarme\C\K\R\ConfigurationRepository->findByStore()
      wp-content/plugins/pagarme-payments-for-woocommerce/vendor/pagarme/ecommerce-module-core/src/Kernel/Repositories/ConfigurationRepository.php:107
    4. Pagarme\C\K\A\AbstractModuleCoreSetup::loadSavedConfiguration()
      wp-content/plugins/pagarme-payments-for-woocommerce/vendor/pagarme/ecommerce-module-core/src/Kernel/Abstractions/AbstractModuleCoreSetup.php:129
    5. Pagarme\C\K\A\AbstractModuleCoreSetup::updateModuleConfiguration()
      wp-content/plugins/pagarme-payments-for-woocommerce/vendor/pagarme/ecommerce-module-core/src/Kernel/Abstractions/AbstractModuleCoreSetup.php:90
    6. Pagarme\C\K\A\AbstractModuleCoreSetup::bootstrap()
      wp-content/plugins/pagarme-payments-for-woocommerce/vendor/pagarme/ecommerce-module-core/src/Kernel/Abstractions/AbstractModuleCoreSetup.php:75
    7. Woocommerce\P\C\Charges->__construct()
      wp-content/plugins/pagarme-payments-for-woocommerce/src/Controller/Charges.php:27
    8. Woocommerce\Pagarme\Core::load_controllers()
      wp-content/plugins/pagarme-payments-for-woocommerce/src/Core.php:77
    9. Woocommerce\Pagarme\Core::initialize()
      wp-content/plugins/pagarme-payments-for-woocommerce/src/Core.php:70
    10. Woocommerce\Pagarme\Core->__construct()
      wp-content/plugins/pagarme-payments-for-woocommerce/src/Core.php:24
    11. Woocommerce\Pagarme\Core::instance()
      wp-content/plugins/pagarme-payments-for-woocommerce/src/Core.php:221
    12. wcmpLoadInstances()
      wp-content/plugins/pagarme-payments-for-woocommerce/woo-pagarme-payments.php:297
    13. wcmpPluginsLoadedCheck()
      wp-content/plugins/pagarme-payments-for-woocommerce/woo-pagarme-payments.php:320
    14. do_action('plugins_loaded')
      wp-includes/plugin.php:517
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problema de performance no DB’ is closed to new replies.