Long time to save products, pages, articles

  • I got this issue in backend.

    With Brands plugin active, saving/creating products, pages, articles takes 30-40seconds compare to the 1-2 seconds when the plugin is de-active.

    Already tried with no results
    – Disable all plugins except Brands and Woocommerce
    – Downgrade Brands plugin
    – Different PHP version (7, 8, 8.1)
    – Switch Apache/Nginx handler

    Running on WP 6.2, with Flatsome Theme

    Any suggestion to solve this issue?

    I would try to wipe the plugin from database, but I got more or less 150 Brands with logos to re-load this way.. ??

    Many thanx for the support

    • This topic was modified 1 year, 11 months ago by Surf Republic.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Dmytro Holovnia

    (@dholovnia)

    Hi,

    Please install this plugin https://www.ads-software.com/plugins/query-monitor/
    It will shown you all the queries running during page load.

    When plugin installed save page and check the queries. There should be some slow queries and too much queries. Please copy them here to check.

    Regards,
    Dmytro

    Thread Starter Surf Republic

    (@surfrepublic)

    This is the slow query.

    <span style=”text-decoration: underline;”>Query</span>

    SELECT?DISTINCT?meta_key
    FROM?trnd_postmeta
    WHERE?meta_key?NOT?BETWEEN?‘_’
    AND?‘_z’
    HAVING?meta_key?NOT?LIKE?‘\\_%’
    ORDER?BY?meta_key
    LIMIT?30

    <span style=”text-decoration: underline;”>Caller</span>

    1. meta_form()
      wp-admin/includes/template.php:713
    2. post_custom_meta_box()
      wp-admin/includes/meta-boxes.php:816
    3. do_meta_boxes()
      wp-admin/includes/template.php:1445

    <span style=”text-decoration: underline;”>Component</span>

    WordPress Core

    <span style=”text-decoration: underline;”>Raws</span>

    30

    In database Query (in query monitor) the Brands-for-woocommerce are colored in purple, the others are in white.

    Plugin Author RazyRx

    (@razyrx)

    Hello,

    It is query from some other functionality on your site, because brands plugin do not use postmeta functionality.

    Regards,
    Oleg

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Long time to save products, pages, articles’ is closed to new replies.