summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-10-25 10:30:40 +0100
committerYorhel <git@yorhel.nl>2015-10-25 10:30:40 +0100
commitba36a7587afdd5a597631c3430b1995dd4c65e5d (patch)
tree72f3fc7b74b5056c2b3a9c60402b8a9462de7bbc /lib
parent5873b30d78f2883ba8aa7fcc9e5ce3e10b9605ae (diff)
DB::Discussions: Minor improvement to post <-> board filter query2.25
I don't know why I didn't apply this one before, I did make this change when benchmarking the fulltext search queries and with the introduction of the bb_tsvector() function this change pretty much always improves performance.
Diffstat (limited to 'lib')
-rw-r--r--lib/VNDB/DB/Discussions.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Discussions.pm b/lib/VNDB/DB/Discussions.pm
index 79cf7b39..bacc728e 100644
--- a/lib/VNDB/DB/Discussions.pm
+++ b/lib/VNDB/DB/Discussions.pm
@@ -193,7 +193,7 @@ sub dbPostGet {
$o{search} ? (
'bb_tsvector(msg) @@ to_tsquery(?)' => $o{search}) : (),
$o{type} ? (
- 'tp.tid = ANY(ARRAY(SELECT tid FROM threads_boards WHERE type IN(!l)))' => [ ref $o{type} ? $o{type} : [ $o{type} ] ] ) : (),
+ 'tp.tid IN(SELECT tid FROM threads_boards WHERE type IN(!l))' => [ ref $o{type} ? $o{type} : [ $o{type} ] ] ) : (),
);
my @select = (