[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