Slow performance and inconsistent profiling logs

[Alessandro Guido]

Hi everyone.

On a specific review, my RB instance is taking almost 2 minutes to respond. Other reviews on the same instance take considerably less time to respond, so I'm trying to understand what is causing such long response times. 

I've enabled the profiling feature, but I get inconsistent results:

Here you can see that the response was generated in 129 seconds:

[pid: 20|app: 0|req: 1/1] 172.20.0.2 () {58 vars in 1126 bytes} [Mon Jul 20 07:33:39 2020] GET /r/120/?profiling=1 => generated 65983 bytes in 129165 msecs (HTTP/1.1 200) 8 headers in 290 bytes (1 switches on core 0)

The profile logs however only account for ~3.2 seconds:

2020-07-20 07:35:48,615 - INFO -  - profile - Profiling results for /r/120/ (HTTP GET):

2020-07-20 07:35:48,616 - INFO -  - profile - 1632645 function calls (1624660 primitive calls) in 3.185 seconds

What can I do to find out where the remaining 125 seconds are spent?

Thanks.

[Christian Hammond]

Hi Alessandro,

That is absolutely not normal... Understatement of the year, I know, but when you view the review request page, we're primarily working with the database and memcached and using the contents to render the page. Anything truly expensive (like adding in rendered fragments of diffs) happens after the page is sent to the browser.

The exceptions to that are:

1) If you use any custom extensions, that can always introduce an issue.

2) If it's Perforce, we may need to query the repository for a little bit of state (but we cache this in memcached).

To start off, a couple questions:

1) What version of Review Board is this?

2) Any custom extensions?

3) What type of repository are you using on this review request?

4) Can you verify that memcached is working and responsive (Admin UI -> Server Cache)

Christian

--
Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups "Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/0b385ffc-6341-4205-a7ea-8084887e0151n%40googlegroups.com.

--

Christian Hammond

President/CEO of Beanbag

Makers of Review Board