Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Estimate Action Count in Statistics #19775

Merged

Conversation

zeripath
Copy link
Contributor

Exract from #19474

As #19474 appears completely stalled. This PR simply changes the statistic generation to only estimate counts for the Action table. I still believe that estimates would be appropriate for a number of other results - most likely the comment count.

Fix #17506

Signed-off-by: Andrew Thornton art27@cantab.net

Signed-off-by: Andrew Thornton <art27@cantab.net>
@zeripath zeripath added type/bug performance/speed performance issues with slow downs backport/v1.16 labels May 21, 2022
Copy link
Member

@delvh delvh left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I am already reviewing #19474 but if it makes you happy:

@GiteaBot GiteaBot added the lgtm/need 1 This PR needs approval from one additional maintainer to be merged. label May 21, 2022
models/db/context.go Outdated Show resolved Hide resolved
@GiteaBot GiteaBot added lgtm/done This PR has enough approvals to get merged. There are no important open reservations anymore. and removed lgtm/need 1 This PR needs approval from one additional maintainer to be merged. labels May 21, 2022
Co-authored-by: delvh <dev.lh@web.de>
@Gusted Gusted added this to the 1.17.0 milestone May 21, 2022
@codecov-commenter
Copy link

Codecov Report

❗ No coverage uploaded for pull request base (main@468387e). Click here to learn what that means.
The diff coverage is 0.00%.

❗ Current head be7d37c differs from pull request most recent head efdbe63. Consider uploading reports for the commit efdbe63 to get more accurate results

@@           Coverage Diff           @@
##             main   #19775   +/-   ##
=======================================
  Coverage        ?   47.27%           
=======================================
  Files           ?      957           
  Lines           ?   133339           
  Branches        ?        0           
=======================================
  Hits            ?    63034           
  Misses          ?    62654           
  Partials        ?     7651           
Impacted Files Coverage Δ
models/db/context.go 70.10% <0.00%> (ø)
models/statistic.go 0.00% <0.00%> (ø)

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update 468387e...efdbe63. Read the comment docs.

@techknowlogick techknowlogick merged commit ffb7ab3 into go-gitea:main May 21, 2022
@zeripath zeripath deleted the estimate-action-table-count-statistics branch May 22, 2022 11:15
@zeripath
Copy link
Contributor Author

On second thoughts perhaps this shouldn't be backported.

zjjhot added a commit to zjjhot/gitea that referenced this pull request May 22, 2022
* giteaofficial/main:
  [skip ci] Updated licenses and gitignores
  Estimate Action Count in Statistics (go-gitea#19775)
AbdulrhmnGhanem pushed a commit to kitspace/gitea that referenced this pull request Aug 24, 2022
jolheiser pushed a commit that referenced this pull request Dec 30, 2022
The `EstimateCount` could be incorrect when the table lives in multiple
schemas. Related to #19775.
@go-gitea go-gitea locked and limited conversation to collaborators May 3, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
lgtm/done This PR has enough approvals to get merged. There are no important open reservations anymore. performance/speed performance issues with slow downs type/bug
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Improve admin dashboard summary display to prevent timeout
9 participants