Changeset a8bbc94

Timestamp:

09/01/10 15:54:15 (21 months ago)

Author:

Benoit Grégoire <benoitg@…>

Branches:

('master', '8434b8322dd6f8ff37c17bd45b94e7a826f86b53')('vitrine', 'afe109c61a407808bd54d88bcccb1cde726a010a')

Children:

20350ca56b01e9f15ed1cff3eb012b98195ffeb4adcd37168d94e3b6860f8f4939162d60be6d1866

Parents:

1b28e2e3cfae5978841cdd9e43cde00f9699a8f0

git-author:

Benoit Grégoire <benoitg@coeus.ca>2010-09-01 15:54:15-04:00

git-committer:

Benoit Grégoire <benoitg@coeus.ca>2010-09-01 15:54:15-04:00

Message:

Tweak ranking algorithm

Location:

html

Files:

• classes/SearchEngine.php (modified) (2 diffs)
• search.php (modified) (1 diff)

html/classes/SearchEngine.php

@@ -891 +891 @@
             $tsQuery = $this->getSqlSearchTermsTSQuery();
             $sql_langstring_entries_match = "SELECT langstrings_id, langstring_entries_id, value
-            ,ts_rank_cd(valuesearchable_index_col, $tsQuery, 16|4) as rank
+            ,ts_rank_cd(valuesearchable_index_col, $tsQuery, 4) as rank
              FROM langstring_entries
              WHERE valuesearchable_index_col @@ $tsQuery";
-            //$db->ExecuterSql("$sql_langstring_entries_match ORDER BY rank desc", $temp,  true);
+            //$db->ExecuterSql("$sql_langstring_entries_match ORDER BY rank desc", $temp,  true);//For debug only!
             $sql = "CREATE TEMP TABLE {$this->value_match_table} AS $sql_langstring_entries_match;";
             $sql .= "CREATE INDEX {$this->value_match_table}_idx ON {$this->value_match_table} (langstrings_id)";
@@ -1001 +1001 @@
         //$db->ExecuterSql("SELECT * FROM {$this->lom_match_table}", $learning_objects_results, true);// For debug only
         // get stats and results
-        $sql = "SELECT COUNT({$this->lom_match_table}.lom_id) as count, SUM(rank)/(10*COUNT({$this->lom_match_table}.lom_id)) AS total_rank, $selectListStr FROM {$this->lom_match_table} JOIN lom on ({$this->lom_match_table}.lom_id=lom.lom_id) {$this->additional_join_string} GROUP BY {$this->lom_match_table}.lom_id, lom.validation_date, $selectListStr ORDER BY {$this->ordering_criteria_sql} {$this->ordering_direction_sql}";
+        $sql = "SELECT COUNT({$this->lom_match_table}.lom_id) as count, SUM(rank)/log(10*COUNT({$this->lom_match_table}.lom_id)) AS total_rank, $selectListStr FROM {$this->lom_match_table} JOIN lom on ({$this->lom_match_table}.lom_id=lom.lom_id) {$this->additional_join_string} GROUP BY {$this->lom_match_table}.lom_id, lom.validation_date, $selectListStr ORDER BY {$this->ordering_criteria_sql} {$this->ordering_direction_sql}";
         $db->ExecuterSql($sql, $learning_objects_results, false); // Store the results
         $this->learning_objects_results = & $learning_objects_results;

html/search.php

@@ -156 +156 @@
     echo "<h1>".sprintf(_("Unknown action: %s"), $_REQUEST['action'])."</h1>";
 }
-
+@ob_flush();flush();