[limb-svn] r6938 - 3.x/trunk/limb/dbal/src/drivers/pgsql

[svn at limb-project.com]

Author: svk
Date: 2008-04-17 08:54:41 +0400 (Thu, 17 Apr 2008)
New Revision: 6938
URL: http://fisheye.limb-project.com/changelog/limb/?cs=6938

Modified:
   3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlConnection.class.php
   3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlStatement.class.php
Log:
-- dbal:pgsql driver performance improved

Modified: 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlConnection.class.php
===================================================================
--- 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlConnection.class.php	2008-04-16 16:22:37 UTC (rev 6937)
+++ 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlConnection.class.php	2008-04-17 04:54:41 UTC (rev 6938)
@@ -25,6 +25,7 @@
 {
   protected $connectionId;
   protected $config;
+  protected $statement_number = 0;
 
   function __construct($config)
   {
@@ -44,6 +45,11 @@
     }
     return $this->connectionId;
   }
+  
+  function getStatementNumber()
+  {
+      return ++$this->statement_number;
+  }
 
   function getHash()
   {

Modified: 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlStatement.class.php
===================================================================
--- 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlStatement.class.php	2008-04-16 16:22:37 UTC (rev 6937)
+++ 3.x/trunk/limb/dbal/src/drivers/pgsql/lmbPgsqlStatement.class.php	2008-04-17 04:54:41 UTC (rev 6938)
@@ -196,7 +196,7 @@
     $sql = $this->_handleBindVars($this->sql);
     if (empty($this->statement_name) || !is_resource($this->statement))
     {
-      $this->statement_name = uniqid(time());
+      $this->statement_name = "pgsql_statement_" . $this->connection->getStatementNumber();
       $this->statement = pg_prepare($this->connection->getConnectionId(), $this->statement_name, $sql);
     }    
     if(!$this->statement)
@@ -263,6 +263,8 @@
     return $this->sql;
   }
 
+  
+  
   function getPrepParams()
   {
     return $this->prepParams;