I have a blog with about 200k posts and each one have 20 custom fields.
I've been using WordPress Transients_API to cache queries, in the few cases where it can be used, but it can't be used in some other queries due to the nature of the blog.
My blog is http://fixapk.com
There is a problem when accessing applications (
My code to retrieve the relevant articles using the custom field *'_similar_apps'*, is as follows:
$args = array( 'showposts' => 10, 'post_type' => 'post', 'meta_query' => array( 'relation' => 'OR', array( 'key' => '_similar_apps', 'value' => $mainlink, 'compare' => 'LIKE' ), ), ); $q = new WP_Query( $args ); if ( $q->have_posts() ) : while( $q->have_posts() ): $q->the_post(); // Do something....
But it is very slow.
You can visit following link to open an article and see its speed
...it takes about 6-10 second to load.
So, how can I optimize queries with
Thank you very much!