Page title autocomplete testing

Index on namespace+page_title makes queries fast. General idea for autocomplete: use page_is_redirect filter until fewer than 5 entries, than allow including redirect pages? Problem: pages that have BECOME redirects don't show up, but don't want to show redirects alongside non-redirects.  One solution: query first by non-redirects from the replica db to retrieve a top n, then do a sort by their relevance (rev count) in our dataset.  Still makes discovery of pages potentially fraught, but probably better.

SQL

SELECT page_id, page_namespace, page_title, page_len
FROM page
WHERE page_namespace = 0 AND page_title LIKE "The\_\"%"
LIMIT 100;

SQL

Checking query status...