NEW FEATURE: better debugging and optimization code for db-queries.

added a timer to db_query for debugging/optimizatin

diff --git a/include/db.php b/include/db.php
index 28100a7b8d80b7fbec0493548db5c5738437e1c8..b84a56670c329c3dfb6ef1c16bcaab19f02ada7c 100644 (file)
--- a/include/db.php
+++ b/include/db.php
@@ -61,8 +61,18 @@ function DB_query($query)
   /* debug/optimize the database
   $logfile=fopen('/tmp/DBlog.log','a+');
   fwrite($logfile,"EXPLAIN $query ;\n");
   /* debug/optimize the database
   $logfile=fopen('/tmp/DBlog.log','a+');
   fwrite($logfile,"EXPLAIN $query ;\n");

+
+  $time = microtime();
+  $return = mysql_query($query);
+  $time = $time - microtime();
+
+  fwrite($logfile,"time of above query: $time\n");
+

   fclose($logfile);
   fclose($logfile);

+
+  return $return;

   */
   */

+

   return mysql_query($query);
 }
 
   return mysql_query($query);
 }