Indexes/keys

  • Resolved foxynal1

    (@foxynal1)


    8 years, 2 months ago

    Hi there,
    My hosting company has asked for me to provide them with references to “Indexes/keys” in relation to product information.

    They want to check the MySQL databases to see if they can improve product price loading speeds.

    Can someone suggest what information I need to provide them with?

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

Viewing 1 replies (of 1 total)
  • Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    8 years, 2 months ago

    Products are stored as “posts” in WordPress. So you will find them stored in the wp_posts table with the post_type of product.

    The price, and most other product related info, is stored in the wp_postmeta table. There are three metas: _price, _regular_price, and _sale_price. The post_id column in this table relates to the wp_posts table.

    That said, and I don’t know too many details, but I would recommend keeping an eye on the development blog here: https://woocommerce.wordpress.com/, as there will a post fairly soon I believe about the possibility to store product data in a more efficient way. Can’t say if it will for sure help your situation, but worth being aware of 🙂

    • This reply was modified 8 years, 2 months ago by Caleb Burks.
Viewing 1 replies (of 1 total)

The topic ‘Indexes/keys’ is closed to new replies.