This is an automated email from the ASF dual-hosted git repository.
asf-gitbox-commits pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/allura.git
The following commit(s) were added to refs/heads/master by this push:
new 6f41f0112 add & update some mongo indexes
6f41f0112 is described below
commit 6f41f0112c77136051ef8008e4bd3ac224be2de6
Author: Dave Brondsema <[email protected]>
AuthorDate: Wed May 27 09:53:02 2026 -0400
add & update some mongo indexes
---
Allura/allura/model/discuss.py | 6 +++---
ForgeDiscussion/forgediscussion/model/forum.py | 1 -
ForgeTracker/forgetracker/model/ticket.py | 2 ++
3 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/Allura/allura/model/discuss.py b/Allura/allura/model/discuss.py
index 6c31a8abc..3189db324 100644
--- a/Allura/allura/model/discuss.py
+++ b/Allura/allura/model/discuss.py
@@ -163,7 +163,7 @@ class __mongometa__:
(('app_config_id', pymongo.ASCENDING),
('last_post_date', pymongo.DESCENDING),
('mod_date', pymongo.DESCENDING)),
- ('discussion_id',),
+ ('discussion_id', 'num_replies'),
]
query: Query[Thread]
@@ -533,8 +533,8 @@ class __mongometa__:
('discussion_id', 'deleted', 'status'),
# for update_stats() and thread_id in general
('thread_id', 'status', 'deleted'),
- # for find_posts/query_posts, including full_slug sort which is
useful on super big threads
- ('deleted', 'discussion_id', 'thread_id', 'full_slug'),
+ # for post_count and find_posts/query_posts, including full_slug
sort which is useful on super big threads
+ ('deleted', 'discussion_id', 'thread_id', 'status', 'full_slug'),
]
query: Query[Post]
diff --git a/ForgeDiscussion/forgediscussion/model/forum.py
b/ForgeDiscussion/forgediscussion/model/forum.py
index 7e49e5189..0a40756d1 100644
--- a/ForgeDiscussion/forgediscussion/model/forum.py
+++ b/ForgeDiscussion/forgediscussion/model/forum.py
@@ -148,7 +148,6 @@ class __mongometa__:
name = 'forum_thread'
indexes = [
'flags',
- 'discussion_id',
'import_id', # may be used by external legacy systems
]
diff --git a/ForgeTracker/forgetracker/model/ticket.py
b/ForgeTracker/forgetracker/model/ticket.py
index bbec87215..f95419a0f 100644
--- a/ForgeTracker/forgetracker/model/ticket.py
+++ b/ForgeTracker/forgetracker/model/ticket.py
@@ -647,6 +647,8 @@ class __mongometa__:
'ticket_num',
('app_config_id', 'custom_fields._milestone'),
'import_id',
+ # for stats endpoint:
+ ('app_config_id', 'deleted', 'status'),
]
unique_indexes = [
('app_config_id', 'ticket_num'),
