On Sat, Sep 6, 2014 at 5:30 PM, Nikolas Everett <[email protected]> wrote:
> I don't know the MySQL syntax super well but that query implied that it > will always use the time index and then iterate in time order looking for a > link to the category you want. Unless that category is an appreciable > fraction of the total links I don't imagine that is a good plan. > The index is on (cl_to,cl_timestamp) (and then implicitly cl_from at the end). See maintenance/tables.sql. -- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
_______________________________________________ Mediawiki-api mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
