Author: Stephane Daury

An efficient alternative to paging with SQL OFFSETs

Posted on by Stephane Daury

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!

Posted on by Stephane Daury

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.