Yuichiro ABE

“Meta Accelerator” can speed up meta query.
<ol>
<li>create table for meta query</li>
<li>add filter that change meta query to use new table</li>
<li>not support WP_Query has multi posttype</li>
</ol>

Meta Accelerator

This plugin can greatly speed up your wordpress by flattening your meta tables. 

I tested it on a WooCommerce installation with ~30,000 products with many meta for products. Before this plugin, the products listing in admin section took a lot of time to load, and individual product edit page was impossible to bring up. With this plugin, they come up quite fast after creating a flattened meta table for product post type.

What it does is to take metas recorded for a post type and plant these metas into pre created flat tables. This makes reading/querying any post based on meta very easy. The plugin also hooks into proper filters for meta queries to take over meta querying.

The plugin code is clean, neat, OOP and well crafted. 

Overall a great job.

If developed, this plugin could help a lot of people. Actually, WordPress core should have included such functionality from the start.

Greatly speeds up your WordPress

"Meta Accelerator" can speed up metaquery.

julian1828

THIS PLUGIN IS IN HEAVY DEVELOPMENT!
Extend your site’s querying and sorting functionality using custom field values.
The following function registers queryable fields. 
 register_custom_queryable_field($fieldName, $options);
Simple Example: 
 register_custom_queryable_field(‘city’); 
(The above registers the custom field ‘city’ to be searchable using query variables) 
 http://www.yoursite.com/?city=Anahiem 
(displays posts which have a meta key ‘city’ and a value of ‘Anahiem’)
Advanced Example: 
 register_custom_queryable_field(“price”, array(“dataType”=>”numeric”)); 
(The above registers the custom field “price” to be searchable as a number using query variables) 
 http://www.yoursite.com/?price=500 
(displays posts which have a meta key ‘price’ and a exact value of ‘500’) 
 http://www.yoursite.com/?price_min=200&price_max=800&order_by=price 
(displays posts, sorted by ‘price’, which have a meta key ‘price’ and a value between ‘200’ and ‘800’)
Available Options:
<ul>
<li>dataType
<ul>
<li>text (default)</li>
<li>numeric (receive min/max query variables, see above example)</li>
</ul>
</li>
<li>order
<ul>
<li>If the user uses the “order_by” query variable then this option determines the order. Available options are “ASC” and “DESC”(default)</li>
</ul>
</li>
<li>compare
<ul>
<li>Compare method for text types. Defaults to ‘=’. Recommend ‘LIKE’</li>
</ul>
</li>
</ul>
There is a “order_by” query var made available. This is used by adding <code>&order_by=price</code> to the URL. In this instance, the query would sort based on the “price” field only.
Note: This plugin does not alter any queries when in the backend.

Custom Query Fields

Extend your site's querying and sorting functionality using custom field values.

Meta Accelerator vs Custom Query Fields