[Toolserver-l] About long query/queries

Thu Sep 7 11:56:14 UTC 2006

Hello all,

there is a project in Russian Wikipedia to analyze all articles with
scrict quality requirements (e.g. at least 500 symbols, or at least
1500 symbols for {{stub}}s, or at least 3 internal links and one
external, or at least one section subheader etc.). The result should
be:
  * Total number of "normal articles"
  * Lists of articles filtered by each requirement

To do so, I should either make a long query to iterate through all
articles or running small queries like 'SELECT page_title, page_latest
FROM page WHERE page_title > ? ORDER BY page_title LIMIT 1' (with
substitution of previous page_title fetched).

The problem is that the first way is much more efficient but I'm not
sure that someone will not kill this query.

-- 
Edward Chernenko <edwardspec at gmail.com>