Fast Woo Order Lookup vs MusicIDB Events Calendar

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.

Built for Artists, Venues, Bars, Restaurants and the Music Industry. This plugin uses the MusicIDB API to seamlessly display your events list and calendar onto any WordPress page via a shortcode or theme hooks. With an intuitive dashboard, instant updates to your website, and integration of artists’ music, videos, social links and bios, MusicIDB Event Calendar makes it possible to easily launch a fully featured calendar for your website visitors. Artists Modern, compact list view launched for artists While creating any event, tag or add any venue you play at Each event can display with Facebook event links or ticket links You can tag / add other bands on any show you play, for easy link-sharing with other bands Drop view templates in your local theme to override Request an API key here: Artist API Key Request Venues Supports multiple views including event list with picss, text only list posterboard layout, grid calendar Tag or add any artist/band/dj Tagging bands enables you to build a network of artists to drop on your calendar 10,000+ artists in the database Website visitors can quickly watch videos and play embedded music of artists tagged on your events in a lightbox (pop-up) on your website calendar page Artist media can be embedded from YouTube, Bandcamp, SoundCloud, Spotify and any other services that provide embeddable media. Override views by copying plugin views in your local theme folder MusicIDB calendar views allows event images on each date Pro – Create recurring events such as weekly Open Mic, Karaoke or Trivia events, or weekly promotional events such as food specials, and much more. This plugin requires a MusicIDB.com account and API key, which you can generate from your venue page once it has been claimed and approved. Visit MusicIDB.com to create your account. API Developer information.