Fast Woo Order Lookup

FAQ

Wat is de achtergrond hiervan?

See this WooCommerce issue for an example of the performance problem store owners have. See this Subscriptions issue for another example.

Wat is de oplossing?

Build a trigram lookup table, maintain it, and use it for the queries.

Hoeveel ruimte neemt de trigram lookup tabel in?

It takes about 5-10KiB per order, as MariaDB / MySQL database storage, counting both data and indexes. So, if your site has a million orders, the table will take something like 5-10 GiB.

How long does it take to generate trigram lookup table?

When you activate the plugin, it starts generating the table in the background. Everything continues as normal while the plugin is generating the table.

Generating the table seems to take about ten seconds (in the background) for every thousand orders.

Does it work with High Performance Order Storage (HPOS)?

Yes.

Does it work with pre-HPOS order storage?

Yes.

The lookup table seems to be out of date. I can’t find recent orders. What do I do?

1. Let the author know by creating an issue at https://github.com/OllieJones/fast-woo-order-lookup/issues
2. Deactivate, then activate the plugin. This rebuilds the lookup table.

What is this wp_fwol table created by the plugin?

This table, named with an abbreviation for “Fast Woo Order Lookup”, contains the trigram lookups. It has a terse name to keep queries short. It is dropped automatically if you deactivate the plugin.

My store only has a few hundred orders. Do I need this plugin ?

This plugin addresses database performance problems that only show themselves on stores with many tens of thousands of orders. If your store is smaller than that you probably don’t need it.

Wise owners of rapidly growing stores return regularly to examine their site performance. If your site is still small, it’s better to wait until you actually need performance-enhancing plugins and other features. Installing them “just in case” is ineffective.