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

Checking query status...