內容簡介
**總結:**
- WooCommerce 的訂單和訂閱頁面允許商店所有者通過客戶姓名、電子郵件和其他屬性搜索訂單和訂閱。
- 默認情況下，它進行一般的子字符串搜索。
- 啟用此外掛後，它運行後台過程以創建專用索引表，一個三重子表，以加速該搜索。
- 該三重子表會佔用數據庫空間並需要時間生成。
- 訂單頁面本身包含一個非常緩慢的查詢（將在 Woocommerce 9.0.0 中修復），用於查找 meta_keys。這也修復了該查詢的性能問題。
- 感謝 Jetbrains 提供軟體開發工具，特別是 PhpStorm。
- 很難想象如果沒有 PhpStorm 提供的工具來探索類似 WordPress 這樣的龐大代碼庫，這樣的外掛將如何開發。
**問題與答案:**
<ul>
<li>什麼是 WooCommerce 的 Order and Subscription 頁面的功能？</li>
<ul>
<li>允許商店所有者通過客戶姓名、電子郵件和其他屬性搜索訂單和訂閱。</li>
</ul>
<li>使用默認搜索時可能面臨的問題是什麼？</li>
<ul>
<li>進行一般的子字符串搜索，對於訂單較多的網站速度非常慢。</li>
</ul>
<li>此外掛啟用後會執行哪個背景過程？</li>
<ul>
<li>創建特殊用途的索引表，一個三重子表，以加快搜索速度。</li>
</ul>
<li>此三重子表的缺點是什麼？</li>
<ul>
<li>會佔用數據庫空間並需要時間生成。</li>
</ul>
<li>訂單頁面本身包含的查詢問題解決了什麼問題？</li>
<ul>
<li>修復了查詢性能問題，尤其是對 meta_keys 的查詢。</li>
</ul>
<li>感謝哪家公司提供軟體開發工具？</li>
<ul>
<li>Jetbrains，特別是 PhpStorm。</li>
</ul>
</ul>
外掛標籤
開發者團隊
📦 歷史版本下載
原文外掛簡介
WooCommerce’s Order and Subscription pages allow store owners to search for orders and subscriptions by customer name, email, and other attributes. By default, it does a general substring search. For example, if you put OllieJones into the search box, it will search with LIKE '%OllieJones%' using the leading wildcard %. That’s astonishingly slow on sites with many orders.
Upon activation this plugin uses ActionScheduler to run a background process to create a special-purpose index table, a table of trigrams, to speed up that search. Then it uses those trigrams to search for orders.
The downside: the trigram table takes database space and takes time to generate.
The orders page itself contains a slow query to look up meta_keys. This fixes that query’s performance too, using a cache of available values.
If you have problems
The WordPress and WooCommerce ecosystems offer many optional features enabled by plugins. And, WooCommerce sites run on many different versions of database server. It is not possible to test this plugin on every imaginable combination. So, you may have problems getting it to work.
Sometimes the process of creating the index table does not complete correctly. And, sometimes you cannot find some orders after the index is created.
If you tell the author about these problems, he will attempt to fix them. Please create a support topic, then visit Site Health, view the Info tab, click the Copy Site Info to Clipboard button, and paste that information into the support topic. And, of course, please describe what is going wrong.
Credits
Thanks to Leho Kraav for bringing this problem to my attention.
Thanks to Sebastian Sommer and Maxime Michaud for using early versions of the plugin on large stores, and to Maxime Michaud for creating the transation into French.
Thanks to Jetbrains for the use of their software development tools, especially PhpStorm. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.
How can I learn more about making my WordPress site more efficient?
We offer several plugins to help with your site’s database efficiency. You can read about them here.
