[Labs-l] Query optimization

Jaime Crespo jcrespo at wikimedia.org
Sun Mar 13 11:31:59 UTC 2016


On Thu, Mar 10, 2016 at 12:48 PM, John <phoenixoverride at gmail.com> wrote:
> Take a look at:
>
>  select * from category left join page on page_title = cat_title where
> page_namespace = 14 and cat_pages > 500 and 'fa' NOT IN (SELECT ll_lang FROM
> langlinks where ll_from = page_id)

This is exactly the same query I wrote before (with mine probably
being as fast or faster), but without paging!



More information about the Labs-l mailing list