summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBrion Vibber <brion@pobox.com>2010-03-02 12:06:40 -0800
committerBrion Vibber <brion@pobox.com>2010-03-02 12:06:40 -0800
commitb1ffbf17d3da90f4c509a47c9fd876304ed9e3fc (patch)
treefff8ec3cdff5fe5b872417bf78958324063673da
parent6b134ae4c7e15ce9853bc82545c3beb67a2dfdad (diff)
Performance fix on Sphinx search results: use id instead of created timestamp for reverse date sorting; should give same result but doesn't trigger a filesort.
-rw-r--r--plugins/SphinxSearch/sphinxsearch.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/SphinxSearch/sphinxsearch.php b/plugins/SphinxSearch/sphinxsearch.php
index 71f330828..654b9c9d5 100644
--- a/plugins/SphinxSearch/sphinxsearch.php
+++ b/plugins/SphinxSearch/sphinxsearch.php
@@ -75,7 +75,7 @@ class SphinxSearch extends SearchEngine
{
if ('chron' === $mode) {
$this->sphinx->SetSortMode(SPH_SORT_ATTR_DESC, 'created_ts');
- return $this->target->orderBy('created desc');
+ return $this->target->orderBy('id desc');
}
}