Repository browsing is very slow after upgrade to 1.14 on windows

[snoopydo]

• Gitea version (or commit ref): 1.14.0
• Git version: 2.31.1
• Operating system: windows 10
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No
• Log gist:

Description

Just upgraded my local instance of gitea to 1.14.0 from 1.13.6. Repository browsing has become much slower after upgrading.
Page and Template render times of gone from
1.13.6 Page: 70ms Template: 30ms
1.14.0 Page: 7184ms Template: 4482ms
These times are consistent across page refreshes and service restarts

repository is 85 MiB, approximately 4500 files in 500 folders.

[lunny]

Have you tried twice?

[techknowlogick]

Closing as dupe of #15401

[snoopydo]

@lunny Yes, multiple times, the slow page times are very consistent in the 5-8 seconds range, previously these were a half second or less. I don't have any timings, more of a feeling, but pushing also seems slower

[zeripath]

One quick thought:

What is your PATH in the environment ?

Have you set [git] PATH in the app.ini ?

On Windows often git is added at the end of an extensive PATH variable. Windows does not hash its path and so multiple executions will result in a large slow down.

This was less of a problem prior to switching to git mostly but could be a source of issues.

We also need logs - including router and likely git logs too. Likely some pprof logs too.

It would also be helpful to know if you have switched off the commit cache or not - and some information about your configuration.

But more seriously - it's EXTREMELY unhelpful to not give us logs. Read https://docs.gitea.io/en-us/logging-configuration/#debugging-problems

[lunny]

@techknowlogick This is for repository browsing but that is PR list. I think it's not duplicate issue.

[snoopydo]

I tried playing with my PATH environment variable and also explicitly setting the [git] path setting in the app.ini none of these affected the page times.

I've attached app.ini and the two log files

app-ini.txt
gitea-log.txt
router-log.txt

[lunny]

Could you add this to your app.ini?

[cache]
ENABLED = true

[cache.last_commit]
ENABLED = true

[snoopydo]

Added to app.ini, restarted the service.
No change to either the initial and any subsequent requests, still taking about 7seconds.

[lunny]

Could you enable pprof and give cpu profile file?