diff options
author | Yorhel <git@yorhel.nl> | 2015-10-25 10:30:40 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-10-25 10:30:40 +0100 |
commit | ba36a7587afdd5a597631c3430b1995dd4c65e5d (patch) | |
tree | 72f3fc7b74b5056c2b3a9c60402b8a9462de7bbc /lib/VNDB/DB | |
parent | 5873b30d78f2883ba8aa7fcc9e5ce3e10b9605ae (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/VNDB/DB')
-rw-r--r-- | lib/VNDB/DB/Discussions.pm | 2 |
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 = ( |