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. >
