[aur-dev] [PATCH] Don't hit the database twice per comment on package

Dan McGee dan at archlinux.org
Sat Apr 11 21:37:30 EDT 2009


On Sat, Apr 11, 2009 at 8:34 PM, Dan McGee <dan at archlinux.org> wrote:
> It's performance improvement day today. For non-superusers, we were hitting
> the database twice per comment on a package- once to get the UID, and once
> to check the owner of the comment. The best part is we already knew the
> owner of the comment, and we only need to get our own UID once.
>
> For viewing a package like yaourt, this cuts a single pageview from over 700
> queries to around 18, which is still not great but a pretty big improvement.
>
> Signed-off-by: Dan McGee <dan at archlinux.org>
> ---

Sorry. This patch **IS NOT** good, I sent a draft one instead of the
real one. That will be coming shortly.


More information about the aur-dev mailing list