Fast Woo Order Lookup vs WP Synchro – The Ultimate WordPress Migration Tool

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.

WP Synchro is the ultimate WordPress migration plugin for professionals and agencies. Easily migrate, clone, backup, and synchronize your WordPress site, including database, media, plugins, themes, and custom files. WP Synchro is designed for fast, secure, and customizable migrations between local, staging, and production environments. Key Features (Free): * One-click WordPress database migration (pull/push) * Search/replace in database data (supports serialized data) * Handles migration of database table prefixes between sites * Select specific database tables or migrate all * Automatic cache clearing after migration for popular cache plugins * Secure, encrypted data transfer – no third-party servers * Set up once, run multiple times – perfect for development, staging, and production PRO Features: * File migration: media, plugins, themes, custom files/folders * Only migrate changed files for faster sync * User confirmation before making file changes * Customize migrations down to a single file or folder * Support for basic authentication (.htaccess) * Email notifications on migration success or failure * Database backup before migration * WP CLI command for scheduled migrations (cron) * 14-day free trial for PRO features Typical Use Cases: * Move or clone WordPress sites between servers or hosts * Push local development or staging sites to production * Pull a copy of a live site for debugging or development * Keep staging and production in sync * Back up your WordPress site Quick Start Install WP Synchro on both source and destination WordPress sites. Activate the plugin via the Plugins menu. Create a new migration job in WP Synchro. Select what to migrate: database, files, or both. Run the migration and watch your site move! Rerun the same migration anytime with one click. Support & Documentation For detailed documentation and support, visit WP Synchro Documentation.