Changeset 27336 for trunk/include/functions_tag.inc.php

Timestamp:

Feb 11, 2014, 10:47:44 PM (10 years ago)

Author:

rvelices

Message:

arrayfromquery optimizations: move double if from inside loop to outside + use directly mysqli calls to avoid function call overhead for every row retrieved from db

File:

• trunk/include/functions_tag.inc.php (modified) (3 diffs)

trunk/include/functions_tag.inc.php

@@ -71 +71 @@
   GROUP BY tag_id
 ;';
-  $tag_counters = simple_hash_from_query($query, 'tag_id', 'counter');
+  $tag_counters = query2array($query, 'tag_id', 'counter');
 
   if ( empty($tag_counters) )
@@ -234 +234 @@
   $query .= "\n".(empty($order_by) ? $conf['order_by'] : $order_by);
 
-  return array_from_query($query, 'id');
+  return query2array($query, null, 'id');
 }
 
@@ -321 +321 @@
     OR ', $where_clauses);
 
-  $result = pwg_query($query);
-  $tags = array();
-  while ($row = pwg_db_fetch_assoc($result))
-  {
-    $tags[] = $row;
-  }
-  return $tags;
+  return query2array($query);
 }