diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-08 15:56:58 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-08 15:56:58 +0000 |
| commit | 8047e0d9c9545b89de29978e45ffc5fd595f18fa (patch) | |
| tree | c935d253ef0a388b3b3ebe94ac1dc33accb25ad8 | |
| parent | 3497f2adab9fb2e05afb584c1eb3904cb3dba17f (diff) | |
| download | forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar.gz forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar.bz2 forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.tar.xz forums-8047e0d9c9545b89de29978e45ffc5fd595f18fa.zip | |
Number of queries executed ... for testing only
git-svn-id: file:///svn/phpbb/trunk@603 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/mssql.php | 3 | ||||
| -rw-r--r-- | phpBB/db/mysql.php | 3 | ||||
| -rw-r--r-- | phpBB/db/odbc.php | 3 | ||||
| -rw-r--r-- | phpBB/db/oracle.php | 4 | ||||
| -rw-r--r-- | phpBB/db/postgres7.php | 3 | ||||
| -rw-r--r-- | phpBB/includes/page_tail.php | 13 |
6 files changed, 21 insertions, 8 deletions
diff --git a/phpBB/db/mssql.php b/phpBB/db/mssql.php index 032e00587a..2f79ae042b 100644 --- a/phpBB/db/mssql.php +++ b/phpBB/db/mssql.php @@ -36,6 +36,7 @@ class sql_db var $query_limit_success; var $next_id; var $row; + var $num_queries = 0; // // Constructor @@ -100,8 +101,10 @@ class sql_db // unset($this->query_result); unset($this->row); + if($query != "") { + $this->num_queries++; if($transaction == BEGIN_TRANSACTION) { $result = mssql_query("BEGIN TRANSACTION", $this->db_connect_id); diff --git a/phpBB/db/mysql.php b/phpBB/db/mysql.php index 9afe8acbe8..0e123a8244 100644 --- a/phpBB/db/mysql.php +++ b/phpBB/db/mysql.php @@ -30,6 +30,7 @@ class sql_db var $db_connect_id; var $query_result; var $row; + var $num_queries = 0; // // Constructor @@ -100,6 +101,8 @@ class sql_db unset($this->query_result); if($query != "") { + $this->num_queries++; + $this->query_result = @mysql_query($query, $this->db_connect_id); } if($this->query_result) diff --git a/phpBB/db/odbc.php b/phpBB/db/odbc.php index 6b21346603..6ac3d376d7 100644 --- a/phpBB/db/odbc.php +++ b/phpBB/db/odbc.php @@ -34,6 +34,7 @@ class sql_db var $next_id; var $row; var $row_index; + var $num_queries = 0; // // Constructor @@ -126,6 +127,8 @@ class sql_db unset($this->row); if($query != "") { + $this->num_queries++; + if($this->db_type == "msaccess") { $query = str_replace("LOWER(", "LCASE(", $query); diff --git a/phpBB/db/oracle.php b/phpBB/db/oracle.php index 42664ca45d..a7dc09eb33 100644 --- a/phpBB/db/oracle.php +++ b/phpBB/db/oracle.php @@ -30,7 +30,7 @@ class sql_db var $db_connect_id; var $query_result; var $row; - + var $num_queries = 0; // // Constructor @@ -90,6 +90,8 @@ class sql_db unset($this->query_result); if($query != "") { + $this->num_queries++; + if(eregi("LIMIT", $query)) { preg_match("/^(.*)LIMIT ([0-9]+)[, ]*([0-9]+)*/s", $query, $limits); diff --git a/phpBB/db/postgres7.php b/phpBB/db/postgres7.php index 981439cc10..df5d8edc4c 100644 --- a/phpBB/db/postgres7.php +++ b/phpBB/db/postgres7.php @@ -32,6 +32,7 @@ class sql_db var $in_transaction = 0; var $row; var $rownum = array(); + var $num_queries = 0; // // Constructor @@ -122,6 +123,8 @@ class sql_db unset($this->query_result); if($query != "") { + $this->num_queries++; + $query = preg_replace("/LIMIT ([0-9]+),([ 0-9]+)/", "LIMIT \\2, \\1", $query); if($transaction == BEGIN_TRANSACTION) diff --git a/phpBB/includes/page_tail.php b/phpBB/includes/page_tail.php index 7913a1c697..adf403bd6b 100644 --- a/phpBB/includes/page_tail.php +++ b/phpBB/includes/page_tail.php @@ -42,12 +42,6 @@ $template->assign_vars(array( $template->pparse("overall_footer"); // -// Close our DB connection. -// -$db->sql_close(); - - -// // Output page creation time // $mtime = microtime(); @@ -56,7 +50,12 @@ $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $totaltime = ($endtime - $starttime); -printf("<center><font size=-2>phpBB Created this page in %f seconds.</font></center>", $totaltime); +printf("<center><font size=-2>phpBB Created this page in %f seconds : " . $db->num_queries . " queries executed</font></center>", $totaltime); + +// +// Close our DB connection. +// +$db->sql_close(); // // Compress buffered output if required |