An efficient alternative to paging with SQL OFFSETs

Challenge Running WordPress.com means having multimillion-record database tables. Tables which we often need to batch-query. Provided we could hardly select (or update, etc) millions of records at once and expect speed, we commonly have to “page” our scripts to only handle a limited number of records at once, then move on to the next batch. ... Read More.

Like elasticsearch? We do too!

Elasticsearch, if you’re not familiar with it, is defined as a distributed restful search and analytics tool. When it comes to implementing such an infrastructure, our developers not only face the challenges involved in indexing tens of millions of sites with grace and skill, they also write quite extensively about their related adventures, so others can benefit ... Read More.

Developer Plugin 1.2.2 Released: New WP-CLI Command

Version 1.2.2 of the Developer plugin was recently released. The big feature of this release is a new WP-CLI command. If you’re not familiar with WP-CLI, it is “a set of command-line tools for managing WordPress installations.” These command-line tools let you do anything from download and install WordPress to manage options for your site. The command we’ve introduced ... Read More.

Page 1 Page 6 Page 7 Page 8 Page 9 Page 10