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 On Mon, Jul 20, 2020 at 6:47 AM Alessandro Guido <[email protected]> wrote: > 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. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/reviewboard/0b385ffc-6341-4205-a7ea-8084887e0151n%40googlegroups.com > <https://groups.google.com/d/msgid/reviewboard/0b385ffc-6341-4205-a7ea-8084887e0151n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Christian Hammond President/CEO of Beanbag <https://www.beanbaginc.com/> Makers of Review Board <https://www.reviewboard.org/> -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/CAE7Vndk%2Bu9XYKOAAOneeBQeJ04fysnZ2x_Z72HHduBbOKV-kDQ%40mail.gmail.com.
