[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] gforge/common/tracker Artifact.class,1.15,1.16
From: |
tom |
Subject: |
[Gforge-commits] gforge/common/tracker Artifact.class,1.15,1.16 |
Date: |
Fri, 12 Mar 2004 10:34:02 -0600 |
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.
*
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/common/tracker Artifact.class,1.15,1.16,
tom <=