Hi Stephen, We're running on MySQL. I don't know why you'd be seeing such a huge delay with PostgreSQL though. Can you tell me which pages are showing delays? (Is it all of them?)
if it's the dashboard, there are some known slowdowns when reaching large numbers of review requests. If the diff viewer, make sure your memcached is caching aggressively. One thing you could try doing is going into Settings -> Logging and turn on Profiling. Then you can visit a page with slowdowns and run with ?profiling=1. This should output to a reviewboard.prof file in the logging directory with some details on the SQL queries and the code paths hit. If you could pass that on to me, I could take a look. Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Thu, Jun 10, 2010 at 11:56 AM, Stephen Gallagher < step...@gallagherhome.com> wrote: > Well, right now 4-8s for a page refresh is just barely within the tolerable > limits of my users. I'm trying to determine whether it makes more sense to > migrate to MySQL (if it would be better performance) > > I was also curious whether ReviewBoard's reference implementation was > running on postgresql and whether there were any tuning tricks I should be > aware of. > > > On 06/10/2010 02:53 PM, Jan Koprowski wrote: > >> It is probably between SQLite and PostgreSQL. But this is delay is >> proportional to scalable. SQLite is not scalable at all, PostgreSQL is >> most scalable free SQL database. >> >> On Jun 9, 9:39 pm, Stephen Gallagher<step...@gallagherhome.com> >> wrote: >> >> >>> I'm curious, what database is thehttp://reviews.reviewboard.orgserver >>> using? We deployed on PostgreSQL recently, and I've noticed a distinct >>> performance issue with it. >>> >>> I can only directly compare it to SQLite, but of course that's local >>> access. But we went from< 1s responses on webpages to 4-8s per page >>> when backed by Postgresql (on a private network with very little >>> traffic). >>> >>> How is the performance when backed by MySQL? >>> >>> >> >> > > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en