aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMax Magorsch <arzano@gentoo.org>2020-06-23 18:41:38 +0200
committerMax Magorsch <arzano@gentoo.org>2020-06-23 18:41:38 +0200
commit5fb992caddd6a3694629ff12219a22135fb19d85 (patch)
tree82e54dfd069d3c8a911cfaa270fb2d663353a784
parentSpeed up loading the threads for a list (diff)
downloadarchives-5fb992caddd6a3694629ff12219a22135fb19d85.tar.gz
archives-5fb992caddd6a3694629ff12219a22135fb19d85.tar.bz2
archives-5fb992caddd6a3694629ff12219a22135fb19d85.zip
Speed up computation of /{{listname}}/
Signed-off-by: Max Magorsch <arzano@gentoo.org>
-rw-r--r--pkg/app/list/show.go7
1 files changed, 1 insertions, 6 deletions
diff --git a/pkg/app/list/show.go b/pkg/app/list/show.go
index 79ea8f2..db5f237 100644
--- a/pkg/app/list/show.go
+++ b/pkg/app/list/show.go
@@ -4,7 +4,6 @@ import (
"archives/pkg/cache"
"archives/pkg/database"
"archives/pkg/models"
- "github.com/go-pg/pg/v10/orm"
"net/http"
"strings"
)
@@ -26,11 +25,7 @@ func ComputeShowTemplateData(listName string) interface{} {
MessageCount int
}
err := database.DBCon.Model((*models.Message)(nil)).
- WhereGroup(func(q *orm.Query) (*orm.Query, error) {
- q = q.WhereOr(`subject LIKE '[` + listName + `]%'`).
- WhereOr(`subject LIKE 'Re: [` + listName + `]%'`)
- return q, nil
- }).
+ Where("list = ?", listName).
ColumnExpr("to_char(date, 'YYYY-MM') AS combined_date").
ColumnExpr("count(*) AS message_count").
Group("combined_date").