Maybe joining then sorting the rev tables of enwiki, dewiki, and frwiki. That would be a possibly useful query that someone might want to do, but we cant do it.
 
Can we limit the amount of CPU/processing a query could take? If not, that would be a very useful MySQL function. We could then run those queries but expect them to take a lot longer.

-Matt

---

> Date: Fri, 26 Oct 2007 13:56:49 -0400
> From: Simetrical+wikilist@gmail.com
> To: toolserver-l@lists.wikimedia.org
> Subject: Re: [Toolserver-l] Database Query Service
>
> On 10/26/07, Edward Chernenko <edwardspec@gmail.com> wrote:
> > 2 SELECT page_namespace FROM page WHERE page_title=? ORDER BY page_namespace
> > (this list may be written into mysql table).
> >
> > User can inflict query by accessing some script common for all
> > queries, which would find query by it's number (query_id) and print
> > HTML form on GET (with textfields instead of placeholders) or results
> > on POST.
>
> Permitting anonymous users to scan the page table seems like a pretty
> good DoS vector for whatever server is being sacrificed for this.
>
> _______________________________________________
> Toolserver-l mailing list
> Toolserver-l@lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/toolserver-l

---

Express yourself instantly with MSN Messenger! MSN Messenger