diff options
author | Lunny Xiao <xiaolunwen@gmail.com> | 2025-03-20 10:46:18 -0700 |
---|---|---|
committer | GitHub <noreply@github.com> | 2025-03-20 10:46:18 -0700 |
commit | a4df01b5802c62863cdf26dc747e20617d847d89 (patch) | |
tree | 3d9d17ffc6040036589e37c879c6afcc74fbc0fa /modules/templates/util_avatar.go | |
parent | ef0970506f360977fbd74afe1952e246783da2b4 (diff) | |
download | gitea-main.tar.gz gitea-main.zip |
Two SQLs are very slow when `action` table have over 5M records.
```
database duration=1.8881s db.sql="SELECT created_unix DIV 900 * 900 AS timestamp, count(user_id) as contributions FROM `action` WHERE user_id=? AND act_user_id=? AND (created_unix > ?) GROUP BY timestamp ORDER BY timestamp"
database duration=1.5408s db.sql="SELECT count(*) FROM `action` WHERE (user_id = ?) AND (is_deleted = ?)"
```
This will cache the count for the first loading or when the activities
changed.
Diffstat (limited to 'modules/templates/util_avatar.go')
0 files changed, 0 insertions, 0 deletions