Precalculate int property of fields to reduce iterate() overhead

1 files changed, 5 insertions, 1 deletions

diff --git a/it_dbi.class b/it_dbi.class
index b2c78ef..5552c6d 100644
--- a/it_dbi.class
+++ b/it_dbi.class
@@ -41,6 +41,7 @@ class it_dbi
 
 	var $_key;	# Key of currently loaded record or null (public readonly)
 	var $_fields;	# Array of name => array(Field,Type,Null,Key,Default,Extra,Length) of fields (public readonly)
+	var $_isint;	# Array of name => bool if field is an INT field
 	var $_link;	# DB link identifier (private)
 
 
@@ -492,7 +493,7 @@ function iterate()
 		if ($this->_data = mysql_fetch_assoc($this->_result))
 		{
 			foreach ($this->_data as $field => $value)
-				$this->$field = ($this->_fields[$field]['Type'] == 'int(11)') ? ($this->_data[$field] = intval($value)) : $value;
+				$this->$field = $this->_isint[$field] ? ($this->_data[$field] = intval($value)) : $value;
 
 			if (!empty($this->_p['keyfield']))
 				$this->_key = $this->_data[$this->_p['keyfield']];
@@ -620,7 +621,10 @@ function _get_field_info()
 	{
 		debug("it_dbi(): no fields for {$this->_p['dbid']}.{$this->_p['table']}, calculating.", 5);
 		for ($res = $this->query('SHOW COLUMNS FROM ' . $this->_p['table']); $field = mysql_fetch_assoc($res);)
+		{
 			$this->_fields[$field['Field']] = $field + array('Length' => preg_match('/date|time/', $field['Type']) ? 20 : intval(it::match('\d+', $field['Type'])));
+			$this->_isint[$field['Field']] = $field['Type'] == "int(11)";
+		}
 
 		$GLOBALS['it_dbi']->_state[$this->_p['dbid']]['fields'][$this->_p['table']] = $this->_fields;
 	}