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! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/