Home / Blog / Performance / Testing an Online Store with 500K of Products powered by WooCommerce

Testing an Online Store with 500K of Products powered by WooCommerce

13 July 18
Reading Time: 3 minutes
No Comments
1 Star2 Stars3 Stars4 Stars5 Stars (9 votes, average: 4.22 out of 5)

In the article we’ll describe our experience of testing a high-loaded online store with 500K products and we’ll do a brief performance analysis of such an online store.  

The test site address  is https://highload.premmerce.com/

The number of products: 500000

The number of categories: 1000

The number of brands: 100

The number of attributes: 100

Active plugins:

Theme: GrandStore.

The site demo data was created with the help of Premmerce Dev Tools plugin.

Additional settings:

  • The optimized filter enabled with the help of Premmerce WooCommerce Product Filter plugin
  • Installed Premmerce Premium with the in-built Rocket Cache plugin and some additional optimization settings for it in order to achieve the maximum load speed of an online store
  • The ‘Rocket cache sitemap.xml based cache preloading’ setting is enabled
  • The ‘Rocket cache Enable cache for logged in users’ setting is enabled
  • The Premmerce ‘Use the same cache for all logged in users’ setting is enabled

Cache setup is of a great importance for a high loaded store. Particular attention must be drawn to making a full cache preload for all pages. Beware not to delete the cache of the whole site during further operation. However, the cache of the changed pages can be deleted.

Server settings

By all means, the proper  server settings should be made for the 500K store. In some cases the use a powerful VDS is recommended.  

We’ve included the following basic settings for this test:

  • Xeon® CPU E3-1275 v6 @ 3.80GHz
  • SSD
  • RAM 2GB

Update! We’ve launched a brand new plugin for WooCommerce Performance Optimization. Get all the details here: WooCommerce Performance Optimization

The Results of the Testing

After filling up with the demo data, we’ve got the following site:

Google PageSpeed Insights

First of all, after heating the site with a cache, we tested it using Google PageSpeed Insights. We’ve got the following results:

The homepage:

The Category page:

The Product page:

So we’ve got a good result on all main pages.

Load Testing

For testing the load in dynamics with a large number of simultaneous users, we used the service: https://loadimpact.com/

We set 50 simultaneous virtual users in the test settings.

HomepageCategoryFiltering products on the category page with 500 products Filtering products on the category page with 57 000 products
The number of all queries284284272261
The number of virtual users50505050
The minimum page load time380.18ms292.95ms1.76s1.88s
The average page load time594.99ms710.92ms2.15s2.38s
The maximum page load time2.1s2.28s3.13s4.77s
The minimum server response time110.19ms120.73ms847.94ms903.7ms
The average server response time181.43ms219.49ms1.06s1.17s
The maximum server response time760.3ms1.27s1.94s3.14s

As we see, the average page load time increases only when filtering up to 2.4 seconds, which is still less than the normal time up to 3 seconds.

All other pages show an excellent result of the full page load up to 1 second and the server response time is up to 200 ms, which is better than most sites on the Internet

However, the filters can also be cached, after that they’ll produce the results as the rest of the site, other points can be optimized individually in real conditions.

Let’s remind that we’ve tested 500K of products in the catalog with 50K of products in one category with 100 attributes – these conditions are a bit unreal, but we’ve decided to take the maximum to demonstrate all the possibilities.

Update! We’ve launched a brand new plugin for WooCommerce Performance Optimization. Get all the details here: WooCommerce Performance Optimization


In general, our test has confirmed once again that high-loaded stores with large databases can be launched using WordPress, WooCommerce and Premmerce plugins.

If you have any other questions or if you need help with setting up or optimizing your online store with a large products database or workload, contact the chat or leave comments, we’ll be happy to help you.

Comments (0)

Leave a Reply

Your email address will not be published. Required fields are marked *


What clients say about Premmerce

Premmerce team are great at their job and we’ll continue to work with them. They are responsive and offer a great customer service! Our Project Manager has perfect communication and collaboration skills, and regularly comes up with some smart suggestions/options that move things forward.
Riley Pearcy
They deeply care about their customers — you can trust Premmerce. A highly talented team that doesn't quit until you're satisfied. Communication skills and problem solving are exactly what Premmerce's strength are. We are happy with the result they have delivered and will work again on the next phase. Thank you!
The entire Premmerce team is truly amazing. They understand the business cases and are able to thoroughly translate those into technical deliverables. Their communication is superb and you will not need to go back and forth on trivial matters. Additionally, they are able to suggest very helpful alternative routes or solutions when necessary.
Rommie Mercer
Order service
[contact-form-7 404 "Not Found"]