[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