From d68b2fa2ea0ef193ca1d9d906a8e8071dd191e77 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Tue, 24 Feb 2009 20:26:08 -0800
Subject: NEW FEATURE: better debugging and optimization code for db-queries.

added a timer to db_query for debugging/optimizatin
---
 include/db.php | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'include')

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);
 }
 
-- 
cgit v1.2.3-18-g5258