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