I beg to differ with the previous two comments. Using a static home page results in WP using an index scan on the posts table’s primary key, vs an (oh so occasional) index scan on post_date, status or post_parent in the posts table. In essence, the home page is dead slow because of the poor … Read more
So the only reason you want to re-architect WordPress to use multiple tables for different post types is because your posts table is getting bigger too fast? I assume the underlying issue for you is that performance is suffering? Instead, I suggest adding appropriate indexes to the post table for the queries you are finding … Read more
Trying using the Object Cache plugin discussed at: http://www.readwriteweb.com/hack/2010/09/how-to-speed-up-the-wordpress.php Another tip would be to install php-apc; see: http://www.readwriteweb.com/hack/2010/09/hack-of-the-day-speeding-up-wordpress-on-a-vps.php Hope this helps!
The basic problem for a script solution is: rel_canonical does not offer any useful filter. So we have to replace that function: remove_action( ‘wp_head’, ‘rel_canonical’ ); add_action( ‘wp_head’, ‘t5_canonical_subpages’ ); The next problem: $GLOBALS[‘numpages’] is empty before setup_postdata(). We could call that function already here, but it might have side-effects. Here is a solution that … Read more
Have a look at the meta_query_find_compatible_table_alias filter defined in wp-includes/class-wp-meta-query.php. This filter’s documentation: /** * Filters the table alias identified as compatible with the current clause. * * @since 4.1.0 * * @param string|bool $alias Table alias, or false if none was found. * @param array $clause First-order query clause. * @param array $parent_query Parent … Read more
Your specific questions: 1) There is no strict limit to the “number of entries” a DB may contain before performance is affected. Performance depends just as much on your hardware and configuration as it does on the size and structure of the DB. 2) If you’re worried about the scalability of your DB layer, you … Read more
What precision do you need? if it’s a state/national wide search maybe you could do a lat-lon to zip lookup and have precomputed distance from zip area to zip area of the restaurant. If you need accurate distances that won’t be a good option. You should look into a Geohash solution, in the Wikipedia article … Read more
Excellent responses on WP Hackers: http://lists.automattic.com/pipermail/wp-hackers/2012-June/043213.html What you’re doing with that query, is loading EVERY matching post into memory, including the full post contents. As you can imagine, this is probably quite a lot of items. You can pass ‘fields’ => ‘ids’ into WP_Query to simply return a list of matching post_ids instead, which should … Read more
Keep in mind that the $content_width global is not only used for images, but also for embedded objects, such as video. So, any solution won’t merely be a case of dropping use/support of $content_width itself. Usually a Theme will constrain content-area images in a few ways: Large Image size: Defining $content_width something appropriate for the … Read more
Siege. Test against both an actual post/page (which would theoretically hit page cache, APC, varnish, etc. for every request after the first request), and against a 404 (e.g., randomly generated strings), which would require database queries on each hit. A few helpful flags: -b benchmark (don’t wait between requests) -c N where N is the … Read more