Fast Woo Order Lookup vs Search Regex

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.

Search Regex adds a powerful set of search and replace functions to WordPress posts, pages, custom post types, and other data sources. These go beyond the standard searching capabilities, and allow you to search and replace almost any data stored on your site. In addition to simple searches you have the full power of PHP’s regular expressions at your disposal. You can use this to do things like: – Help migrate a site from one domain to another – Update URLs in links and images – Perform site-wide changes Search filters can be created to match any column of any WordPress table. For example: – Find all posts in a category – Find all post meta data without a post – Find all posts in a date range Search Regex handles small and large sites. Search Regex has been tested with PHP from 7.4 to 8.4. What can I search? You can search: – Posts – Pages – Any custom post type – Comments (including spam) – Users – Meta data – WordPress options Full regular expression support is provided, and you can capture data and use it in the replacement. Actions A variety of actions can be performed on matching results: – Modify and replace the result – Delete the result – Export to CSV and SQL – Perform custom PHP action Modify and Replace Data Results can be individually modified by clicking on the item to change, and using the popup modifier. Bulk modifications can be performed against all matching results. The types of modification depend on the data being changed: – Numbers can be added or subtracted to existing numbers – Hours, days, weeks, and months, can be added to dates – Tags and categories can be added, removed, and substitued Custom shortcodes are supported that allow dynamic data to be included: – Add the current date and time, in any format, to content – Insert data from other columns. For example, insert the category into the title – Transform existing data. For example, convert case, change underscores to dashes. Example uses Some ideas for potential uses: – Delete all comments that match a phrase – Add a category to all matching posts – Remove orphaned meta data Support Please submit bugs, patches, and feature requests to: https://github.com/johngodley/search-regex Please submit translations to: https://translate.wordpress.org/projects/wp-plugins/search-regex Translations Translations are provided by WordPress itself. You can update the translations by going to the Dashboard > Updates section of WP admin. Documentation Full documentation can be found on the Search Regex site.