Here is my final layout, i still yet to test it on the production machine
being a dual 2G xeon, has had major performance issues generated list menus
onto the screen and load time.
function asset_type_list2($tID=null,$tab_index = null,$cache_data =
null,$disabled = null) {
global $db;
if ($cache_data) {
$query = $db->check_menu_cache
('asset_types','asset_type');
} else {
$query = "SELECT SQL_NO_CACHE
asset_typeID,asset_type FROM asset_types ORDER BY asset_type ASC";
}
return $db->get_menu2('asset_typeID',$query,set_menu_extras
($tab_index,$disabled),false,$tID,false,CACHE);
}
and in the db class
function check_menu_cache($table,$value_field) {
$query = $this->query("SELECT SQL_CACHE cache_data FROM
cache_menu_table WHERE cache_table='$table'");
if ($this->results()) {
$query = "SELECT SQL_CACHE cache_data FROM
cache_menu_table WHERE cache_table='$table'";
} else {
$query = $this->query("SELECT SQL_NO_CACHE * FROM
$table ORDER BY $value_field ASC");
while ($row = $this->fetchArray($query)) {
$arr[$row[0]] = $row[1];
}
$insertID = $this->insert("INSERT INTO
cache_menu_table (cache_data,cache_table) VALUES ('".serialize
($arr)."','$table')");
$query = "SELECT SQL_CACHE cache_data FROM
cache_menu_table WHERE cacheID IN (".$insertID.")";
}
return $query;
}
What is the purpose of mysql_unbuffered_query i just tried it and killed my
connection
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
