diff options
| author | Brion Vibber <brion@pobox.com> | 2010-02-04 11:06:01 -0800 |
|---|---|---|
| committer | Brion Vibber <brion@pobox.com> | 2010-02-04 11:06:01 -0800 |
| commit | 5a1cbdc6f1e32be7b8430924a1125422d8457584 (patch) | |
| tree | 28147de9aef4dd9fcec909e2ca0a13cc7d204cff /lib/personaltagcloudsection.php | |
| parent | 7a7e2162dd7eed59e60d9360d8692abc111d940c (diff) | |
Add time-based cutoffs for public tag cloud, favorited lists to speed up those queries.
Defaulting to only looking at last 90 days of activity, can be adjusted up or down.
$config['tag']['cutoff'] = 86400 * 90;
$config['popular']['cutoff'] = 86400 * 90;
Per-user and per-group tag clouds do not use the cutoff (and it doesn't help with indexing on them).
Diffstat (limited to 'lib/personaltagcloudsection.php')
| -rw-r--r-- | lib/personaltagcloudsection.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/personaltagcloudsection.php b/lib/personaltagcloudsection.php index 091425f92..5ea3f188d 100644 --- a/lib/personaltagcloudsection.php +++ b/lib/personaltagcloudsection.php @@ -59,6 +59,7 @@ class PersonalTagCloudSection extends TagCloudSection function getTags() { $weightexpr = common_sql_weight('notice_tag.created', common_config('tag', 'dropoff')); + // @fixme should we use the cutoff too? Doesn't help with indexing per-user. $qry = 'SELECT notice_tag.tag, '. $weightexpr . ' as weight ' . |