From: Arun Persaud <arun@nubati.net>
Date: Wed, 25 Feb 2009 04:26:08 +0000 (-0800)
Subject: NEW FEATURE: better debugging and optimization code for db-queries.
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=commitdiff_plain;h=d68b2fa2ea0ef193ca1d9d906a8e8071dd191e77

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 28100a7..b84a566 100644
--- 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");
+
+  $time = microtime();
+  $return = mysql_query($query);
+  $time = $time - microtime();
+
+  fwrite($logfile,"time of above query: $time\n");
+
   fclose($logfile);
+
+  return $return;
   */
+
   return mysql_query($query);
 }