InMotion Hosting Logo

High-Performance Order Storage on WooCommerce

High-Performance Order Storage on WooCommerce - Hero Image

In late 2022, WooCommerce launched plans to optimize the efficiency of WooCommerce Core by focusing on Orders and methods to effectively handle Order knowledge. Originally dubbed the Custom Order Tables undertaking, it has since been renamed to High-Performance Order Storage, or HPOS.

With the discharge of WooCommerce 7.1, an possibility was launched that allowed customers to opt-in / allow High-Performance Order Storage on their on-line shops. In March 2023, WooCommerce builders introduced that HPOS will be enabled by default on all storefronts by August 2023.

This article will cowl what HPOS is, its options, and what modifications it could be bringing for eCommerce retailer house owners.

High-Performance Order Storage on WooCommerce

Out of all of the web sites that use WordPress as a Content Management System (CMS), 8.7% use WooCommerce as an eCommerce platform, making it extra standard than SquareSpace and Shopify.

With WordPress’s focus on Performance rising previously couple of years, builders confirmed curiosity in bettering the efficiency of WooCommerce database tables to be able to streamline the order course of.

In January 2022, the “Plan for the WooCommerce Custom Order Table” article launched the undertaking that might finally turn out to be High-Performance Order Storage.

Understanding HPOS

Until lately, WooCommerce saved their order knowledge throughout the WordPress database below the wp_posts and wp_postmeta tables. This gave customers entry to instruments supplied by WordPress to handle orders.

WooCommerce designed High-Performance Order Storage to fulfill the wants of eCommerce shops utilizing WooCommerce CRUD to retailer knowledge in customized tables optimized for WooCommerce queries.

How to opt-in for HPOS in WooCommerce.
Image Source: WooCommerce

By utilizing this database construction, builders goal to enhance scalability, simplify knowledge storage, and improve reliability for on-line retailers, bettering total web site efficiency.

Since its introduction, WooCommerce experiences {that a} web site’s checkout course of is 1.5x quicker after enabling HPOS.

The Three Goals of HPOS

Per WooCommerce’s preliminary introduction of Custom Order Tables, their three foremost objectives for this undertaking had been the next:

Scalability

In order to fulfill the necessity of shops with rising clientele, tables get separated into particular knowledge subsections, corresponding to order addresses and order titles. This separation much less learn/write operations happen, making certain quicker instances for enterprise no matter their measurement.

Reliability

Because of their separated database tables, it’s simpler to revive knowledge, as customers now can restore the precise misplaced data. Backups of internet sites are subsequently extra dependable and browse/write locks are simpler to implement.

Simplicity

WooCommerce empowers customers to develop higher plugins and extensions with the separation of the wp_posts desk. As storage differentiation will lead to smaller tables, customers can now learn and perceive their database higher.

To get extra data on the main target of HPOS, we suggest studying WooCommerce’s Documentation.

HPOS Implementation

The 4 database desk buildings HPOS introduces are:

  1. Main Order Table – provides columns for regularly used meta values. Some column values embody order id, standing, billing electronic mail, and so forth.
  2. Order Addresses Table – Stores the transport and billing data from clients.
  3. Order Operational Table – Maintains sure order values that aren’t a part of the Main Order Table as they may change sooner or later.
  4. Order Meta Table – acts as a knowledge retailer for WooCommerce extension’s knowledge, just like wp_postmeta.
The four database structures proposed by WooCommerce developers.
Proposed Database Table Structure by WooCommerce in January 2022

Previously all data was saved within the wp_posts and wp_postmeta with a number of joints and lookups wanted for each new order.

The construction of the tables above permit for simpler lookup and technique of orders and shopper data, reducing the time wanted between every request.

Testing Website Performance

On March 17, ten days after the announcement of HPOS as a default, WooCommerce launched the outcomes from a sequence of performance benchmarking tests on a web site using this know-how.

The web site used for the efficiency testing contained 400k orders and 30k merchandise. Both HPOS and WP question cache had been disabled for the preliminary efficiency benchmarks.

Note: The solely efficiency altering modification enabled on the web site used for the experiment was Memcached because of the internet host providing it.

In order to additional take a look at efficiency, builders carried out these duties with just one employee, that means every request could be finished just one on the time, fairly than consecutively as most web sites do at this time. The outcomes of this take a look at subsequently would show increased efficiency if a number of employees had been used.

Improve the efficiency and safety of your WooCommerce web site with our new WooCommerce Hosting plans. Get 40x quicker speeds in your on-line retailer with devoted assets, server caching, and optimization instruments.

check markHigh-Performance VPS check mark99.99% Uptime check markFree SSL & Dedicated IP check markAdvanced Server Caching

View WooCommerce Hosting Plans

Performance Benchmark Test Results

For the needs of this text, we’ll spherical as much as the second decimal place. To evaluate the full breakdown of the take a look at, code used for benchmarking and full outcomes, we suggest studying WooCommerce’s documentation.

  • Order Creation – The time to create 1000 orders was 15.18 seconds when utilizing HPOS, 5x quicker than with the Posts Table.
  • Order Checkout – The time to course of 10 checkouts with HPOS was 0.99 seconds, a 1.5x enhance in efficiency.
  • Search Orders Using Metadata – It took 0.05 seconds to look 1000 orders by metadata through HPOS, a 10x enchancment from Post Tables.
    • Note: With the entry so as to add indexes to the Order Meta desk, knowledge lookup in comparison with the Posts Table is quicker; nevertheless as indexes do decelerate web pace. However, due to the outcomes of the opposite checks, this small enhance in efficiency remains to be a optimistic outcome.
  • Filtering by an Indexed Column – With their improved metadata construction, HPOS can use the index of customer_id to filter 1000 orders for patrons at solely 0.15 seconds, 40x quicker than with Posts Table.
  • Search Orders Using Non-Indexed Column – Although builders nonetheless count on some enchancment on this part, HPOS filtered orders in 0.29 seconds, 3x quicker than Posts Table.

WooCommerce and Database Size

Because of their present work and for the reason that separation of the wp_postmeta would lower the tables MySQL wants to question, it’s attainable to lower the database measurement and subsequently get quicker pace instances.

While this work remains to be in progress, WooCommerce speculates that woocommerce.com would see the submit meta desk knowledge discount of 97% with HPOS.

The New Normal

High-Performance Order Storage is an thrilling and promising new function coming to all WooCommerce web sites; nevertheless, for enterprise house owners who haven’t opted-in on HPOS, the swap to default with WooCommerce 8.0 might increase some considerations.

In order to be ready for the HPOS in August, we suggest reviewing the next gadgets previous to updating your WooCommerce plugin:

  1. Create a backup of your WooCommerce web site
  2. Ensure the present extensions or theme you’ve got are appropriate with HPOS
    • If these extensions use Woo CRUD they’re appropriate, if extensions aren’t appropriate they are going to be deactivated on your retailer
  3. Stay updated with the WooCommerce documentation for the most recent updates

We strongly suggest updating your WooCommerce plugin, as not updating it to be able to maintain an older model can threaten your web site’s safety and future help from WooCommerce.

Final Thoughts

The upcoming modifications to WooCommerce via using High-Performance Order Storage will open new doorways to customers that worth efficiency and pace. Faster order processing, checkout stream, and safety will assist enhance person expertise and sure gross sales for enterprise house owners.

The scalability, reliability, and ease of WooCommerce is why it continues to be one of many largest eCommerce platforms presently out there.

If you’re trying to find a internet hosting plan that provides efficiency out of the field, select InMovement Hosting’s WooCommerce Hosting Plans in your on-line retailer. Our UltraStack cloud infrastructure supplies superior reliability, devoted assets and server-level caching to spice up your on-line retailer’s pace. Leverage W3 Total Cache to allow caching for Redis object storage, database caching, browser caching, lazy loading, and extra.

Additional WooCommerce Resources

Check Also

Stila Cosmetics Dials Up the Glam Factor with Mary Rodrigues as CMO Extraordinaire

Stila Cosmetics Dials Up the Glam Factor with Mary Rodrigues as CMO Extraordinaire

Stila Cosmetics, a distinguished artistry magnificence model, has lately made an thrilling announcement relating to …