[Gforge-commits] gforge/common/tracker Artifact.class,1.15,1.16

[tom]

Update of /cvsroot/gforge/gforge/common/tracker
In directory db.perdue.net:/tmp/cvs-serv20111/common/tracker

Modified Files:
        Artifact.class 
Log Message:
SQL optimization: Replaced a 'select *' with a 'select count(*)' in 
Artifact.class

Index: Artifact.class
===================================================================
RCS file: /cvsroot/gforge/gforge/common/tracker/Artifact.class,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- Artifact.class      28 Feb 2004 14:11:52 -0000      1.15
+++ Artifact.class      12 Mar 2004 16:34:00 -0000      1.16
@@ -552,16 +552,12 @@
                if (!session_loggedin()) {
                        return false;
                }
-               $sql="SELECT * FROM artifact_monitor WHERE 
user_id='".user_getid()."' AND artifact_id='".$this->getID()."';";
-               $result = db_query($sql);
-               if (!$result || db_numrows($result) < 1) {
-                       return false;
-               } else {
-                       return true;
-               }
+    $sql="SELECT count(*) FROM artifact_monitor WHERE 
user_id='".user_getid()."' AND artifact_id='".$this->getID()."';";
+    $result = db_query($sql);
+    $row_count = db_fetch_array($result);
+    return $result && $row_count['count'] > 0;
        }
 
-
        /**
         *  getMonitorIds - array of email addresses monitoring this Artifact.
         *