]> source.dussan.org Git - gitea.git/commit
projects / gitea.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0aedb03) | patch
Perf: add extra index to notification table (#32395)
authorBoYanZh <boyanzh233@gmail.com>
Wed, 13 Nov 2024 18:17:54 +0000 (13:17 -0500)
committerGitHub <noreply@github.com>
Wed, 13 Nov 2024 18:17:54 +0000 (18:17 +0000)
commitad223000d42782d1cd5a2ef9e8cb3a51f76739f9
treed329363fb278c9c01aaa94267c23d3e9279663c8tree | snapshot
parent0aedb03996d7bdce88b1f0086151f8778b10c1a4commit | diff
Perf: add extra index to notification table (#32395)

Index SQL: `CREATE INDEX u_s_uu ON notification(user_id, status,
updated_unix);`

The naming follows `action.go` in the same dir.

I am unsure which version I should add SQL to the migration folder, so I
have not modified it.

Fix #32390
models/activities/notification.go diff | blob | history
models/migrations/migrations.go diff | blob | history
models/migrations/v1_23/v309.go [new file with mode: 0644] blob
Git with a cup of tea! Painless self-hosted all-in-one software development service, including Git hosting, code review, team collaboration, package registry and CI/CD: https://github.com/go-gitea/gitea