Woocommerce Indexing

  • Resolved Krammig

    (@krammig)


    5 years, 8 months ago

    I am somewhat confused having done some searching for information on Indexing tables in WordPress / Woocommerce.

    Bottom line, I am trying to speed up the accessing of Products and also the bulk update for pricing where there are many Sizes and Colours etc against several thousands of products resulting in around 834,000 records in the postmeta table and in posts table 127,000

    My background is MS SQL where we use multiple tables relationships and multiple keys etc. not just one horrendous table like the postmeta.

    I saw the following page

    https://docs.woocommerce.com/document/woocommerce-product-search/settings/index/woocommerce-settings-search-index/

    .. but I’m confused as the Woocomerce I have does not have any indexing tab ?

    I guess my question is basically, is there a way to index Attributes and Product and alike so when importing updates, or even just manually updating data and searching it is much much faster given it is pulling data from Attributes via indexed columns (fields)

    BTW. I am currently running Woo 3.4.5

    thanks

    • This topic was modified 5 years, 8 months ago by Krammig.
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Woocommerce Indexing’ is closed to new replies.