Products WP_TABLE_DISPLAY takes 5-15 secs to execute

  • Resolved immunity20

    (@immunity20)


    6 years, 6 months ago

    I have VPS 8cores 32GBRAM ( only 2GB are used 30 are free)

    I have track with newrelic and i have seen wp-admin/edit.php , archive product, single product and front page (has sliders with products) getting way too high TTFB (5-15 sec)
    In each situation database queries (usually 1-3) takes 10-50ms and the WEBtransaction delay on trying printing the posts(products)

    I have 3500 products with 150 custom attributes (each product can have 1-7 attributes)

    Is this normal? 8 sec in order php agent to respond? (TTFB)
    I have tried also clean install with only woocommerce + storefront and transfer my db again too high query

    folder with photos of monitoring and my conf files
    folder

    • This topic was modified 6 years, 6 months ago by immunity20.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

  • What database engine are you using for MySQL tables? Try to switch from MyISAM to InnoDB and also optimize tables that have performance issues, there is a simple option in PHPMyAdmin to do all that.

    Thread Starter immunity20

    (@immunity20)

    Hey innoDB but i think I had mess up with server configuration.
    a clean install fix it

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Are you all set, or still having trouble @immunity20?

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Products WP_TABLE_DISPLAY takes 5-15 secs to execute’ is closed to new replies.