Files
@ ad374c171656
Branch filter:
Location: kallithea/docs/usage/statistics.rst - annotation
ad374c171656
1.2 KiB
text/prs.fallenstein.rst
comments: introduce lazy join of ChangesetStatus on ChangesetComment
99% of all uses of ChangesetComment will also need the optional corresponding
ChangesetStatus (if any) on the status_change relationship. Fetching it on
demand gives a lot of roundtrips and might be slow ... but adding explicit bulk
queries everywhere do not seem feasible. Adding lazy=joined in the data model
seems like the best solution.
Loading a pull request with 10 comments on a slow repo goes from 3.5 s to
2.7 s.
99% of all uses of ChangesetComment will also need the optional corresponding
ChangesetStatus (if any) on the status_change relationship. Fetching it on
demand gives a lot of roundtrips and might be slow ... but adding explicit bulk
queries everywhere do not seem feasible. Adding lazy=joined in the data model
seems like the best solution.
Loading a pull request with 10 comments on a slow repo goes from 3.5 s to
2.7 s.
bbd499c7b55e bbd499c7b55e 17c9393e9645 bbd499c7b55e bbd499c7b55e bbd499c7b55e e73a69cb98dc 8af52e1224ff e73a69cb98dc 8af52e1224ff bbd499c7b55e bbd499c7b55e 9472a0150bf0 bbd499c7b55e 8af52e1224ff 8af52e1224ff 8af52e1224ff 8af52e1224ff e73a69cb98dc 8af52e1224ff bbd499c7b55e bbd499c7b55e bbd499c7b55e 9472a0150bf0 bbd499c7b55e e73a69cb98dc 8af52e1224ff 8af52e1224ff 8af52e1224ff bbd499c7b55e bbd499c7b55e 8af52e1224ff 8af52e1224ff | .. _statistics:
==========
Statistics
==========
The Kallithea statistics system makes heavy demands of the server resources, so
in order to keep a balance between usability and performance, the statistics are
cached inside db and are gathered incrementally, this is how Kallithea does
this:
With Celery disabled
--------------------
- On each first visit to the summary page a set of 250 commits are parsed and
updates statistics cache.
- This happens on each single visit to the statistics page until all commits are
fetched. Statistics are kept cached until additional commits are added to the
repository. In such a case Kallithea will only fetch the new commits when
updating it's cache.
With Celery enabled
-------------------
- On the first visit to the summary page Kallithea will create tasks that will
execute on celery workers. This task will gather all of the stats until all
commits are parsed, each task will parse 250 commits, and run the next task to
parse next 250 commits, until all of the commits are parsed.
.. note::
At any time you can disable statistics on each repository via the repository
edit form in the admin panel. To do this just uncheck the statistics checkbox.
|