Title: Indexes/keys
Last modified: March 9, 2018

---

# Indexes/keys

 *  Resolved [foxynal1](https://wordpress.org/support/users/foxynal1/)
 * (@foxynal1)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/indexes-keys/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Findexes-keys%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  [Caleb Burks](https://wordpress.org/support/users/icaleb/)
 * (@icaleb)
 * Automattic Happiness Engineer
 * [8 years, 2 months ago](https://wordpress.org/support/topic/indexes-keys/#post-10058831)
 * 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/](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](https://wordpress.org/support/users/icaleb/).

Viewing 1 replies (of 1 total)

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

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Caleb Burks](https://wordpress.org/support/users/icaleb/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/indexes-keys/#post-10058831)
 * Status: resolved