[aur-dev] [PATCH] Notify users when a package is updated.
Mario Mueller
mario at xenji.com
Fri Jul 27 17:45:31 EDT 2012
hm. then why not optimize both, if possible?
On Friday, July 27, 2012, Nicolas Cornu wrote:
> Le 27/07/2012 23:24, Mario Mueller a écrit :
>
>> Just to get a better understanding...
>> why do you need to select the whole fieldset from CommentNotify if you
>> do not use a single value of it?
>>
>> SELECT u.Email FROM Users u
>> INNER JOIN CommentNotify cn ON u.ID=cn.UserID
>> AND cn.UserID != $uid
>> AND cn.PkgID = $packageID
>>
>> does the same from my point of view and returns only one field or do I
>> miss something?
>>
>> In fact, I don't try to "optimize" this request, I only copy the one in
> ./web/lib/pkgfuncs.inc.php in the add_package_comment function.
>
More information about the aur-dev
mailing list