projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
no longer an experiment, RT#22187
[freeside.git]
/
rt
/
sbin
/
rt-fulltext-indexer
diff --git
a/rt/sbin/rt-fulltext-indexer
b/rt/sbin/rt-fulltext-indexer
index
2a6b07e
..
396ef10
100755
(executable)
--- a/
rt/sbin/rt-fulltext-indexer
+++ b/
rt/sbin/rt-fulltext-indexer
@@
-217,6
+217,11
@@
sub attachments {
VALUE => 'deleted'
);
VALUE => 'deleted'
);
+ # On newer DBIx::SearchBuilder's, indicate that making the query DISTINCT
+ # is unnecessary because the joins won't produce duplicates. This
+ # drastically improves performance when fetching attachments.
+ $res->{joins_are_distinct} = 1;
+
return goto_specific(
suffix => $type,
error => "Don't know how to find $type attachments",
return goto_specific(
suffix => $type,
error => "Don't know how to find $type attachments",