speeding up the group/dump query in FAS
Mike McGrath
mmcgrath at redhat.com
Tue Sep 7 02:53:55 UTC 2010
On Mon, 6 Sep 2010, Matt_Domsch at Dell.com wrote:
> Currently this query takes several minutes. HAProxy (or something in the proxy series) times out the request, and returns a 500 to the client.
> https://admin.fedoraproject.org/accounts/group/dump/
>
> Any chance that could be optimized? FWIW, I use this query in my ftbfs script to convert package owner names to email addresses, so I can send the FTBFS report to the owner's emails directly (on bcc).
>
This must be related to the alchemy alterations we did recently. I'll
take a look and see what it would take. I was under the assumption this
particular dump was memcached so it should be very quick but I could be
wrong on that.
-Mike
More information about the infrastructure
mailing list