Jason and I noticed that the detailed bug search form,
http://bugs.darcs.net/issue?@template=search , was very slow (half a minute) for
logged-in users. This is due to the Creator/Actor/Assigned to fields with their
user select lists. I don't fully understand the caching story, but it seems
these queries can take a number of seconds when postgres is cold, even though
the appropriate speedup indexes seem to be in place. I believe because we are
running roundup in cgi mode it does not benefit from postgres caching; with the
persistent server these queries should be instant. 

As a temporary workaround, I replaced the select lists with text fields. If you
want to use these, type in a username, which you can find in the User List in
the sidebar.

On Fri, Sep 19, 2008 at 10:24 PM, Simon Michael <bugs@darcs.net> wrote:

> I believe because we are
> running roundup in cgi mode it does not benefit from postgres caching; with the
> persistent server these queries should be instant.

Simon and I have hypothesized that with something like fastcgi this
slow down may go away after the first time anyone requests that page
to load.

Jason