[aur-dev] [PATCH] Fix performance issues with new PackageDepends lookups

[Lukas Fleischer]

On Mon, Apr 11, 2011 at 08:03:43PM -0500, Dan McGee wrote:
> We do a lookup by DepName in the package details view, but I made the
> silly mistake of forgetting this index addition in the upgrade steps.
> 
> Signed-off-by: Dan McGee <dan at archlinux.org>
> ---
> 
> Lukas- said missing index was the cause of the increased CPU usage/load on
> sigurd, it appears. I already created this index in production as I was the one
> who forgot it in my last set of patches, whoops!

How serious is this? I didn't check server load recently. If this one
really stresses the server, we should probably put this into another
maintainance release instead of 1.9.0 (although I'm not sure if anyone
will care).