Pages I am have worked on / am working on:

Notes

edit
SELECT id, weight() AS w,  w + ((view_cnt + 1) / 10) + (link_cnt * 10) + edit_cnt + (category_cnt * 10) - (edit_age / 10) AS page_rank, view_cnt, link_cnt, edit_age, edit_cnt, category_cnt FROM wiki_main WHERE MATCH('blue ribbon') AND page_namespace=0 AND page_is_redirect=0 ORDER BY page_rank DESC OPTION field_weights=(page_title=100, old_text=1);
SELECT * FROM wiki_main,wiki_incremental WHERE MATCH('control') AND page_namespace=0 AND page_is_redirect=0  ORDER BY weight() + ((view_cnt + 1) / 10) + (link_cnt * 10) + edit_cnt + (category_cnt * 10) - (edit_age / 10) ;

'old_text' => 1, 'page_title' => 100


Changes: sphinx.conf - new queries - query log output - sphinxql listener LocalSettings.php - new params my.ini


Advanced changes LocalSettings.php $wgSearchType = 'SphinxMWSearch'; require_once( "$IP/extensions/SphinxSearch/SphinxSearch.php" ); $wgSphinxSearch_ranker = SPH_RANK_PROXIMITY_BM25; $wgSphinxSearch_sortmode = SPH_SORT_EXPR; $wgSphinxSearch_sortby = '@weight + ((view_cnt + 1) / 10) + (link_cnt * 10) + edit_cnt + (category_cnt * 10) - (edit_age / 10)'; $wgEnableMWSuggest = true; $wgEnableSphinxPrefixSearch = false;

  1. Weights of individual indexed columns. This gives page titles extra weight

$wgSphinxSearch_weights = array( 'old_text' => 1, 'page_title' => 10 );

  1. $wgSphinxSearch_sortmode = SPH_SORT_EXPR;
  2. $wgSphinxSearch_sortby = '@weight + page_counter + (pl_count * 10)';

Indexing

edit

c:\Wiki\Sphinx\sphinx-2.0.6-release-win32\bin>indexer --config C:\Wiki\Sphinx\sp hinx-2.0.6-release-win32\sphinx.conf --all Indexing times for 57,000 articles:

  • Default: 2 mins
  • Basic:
  • Advanced: