On 9/7/06, Edward Chernenko edwardspec@gmail.com wrote: [snip]
The problem is that the first way is much more efficient but I'm not sure that someone will not kill this query.
Are you talking about a query that will be run once or a query that will be executed from a cgi script.
select page_namespace, page_title from page; on ruwiki_p takes under a second... I wouldn't call that a long query.