Changeset 1010 for trunk/common

Timestamp:

03/01/09 12:43:38 (3 years ago)

Author:

bogdan2412

Message:

Cache task parent rounds

​http://reviewboard.infoarena.ro/r/69/

Location:

trunk/common/db

Files:

• round.php (modified) (3 diffs)
• task.php (modified) (2 diffs)

trunk/common/db/round.php

@@ -161 +161 @@
 //
 // $tasks is array of task id's
-function round_update_task_list($round_id, $tasks) {
+function round_update_task_list($round_id, $old_tasks, $tasks) {
     log_assert(is_round_id($round_id));
 
@@ -169 +169 @@
                      db_escape($round_id));
     db_query($query);
-
-    log_print_r($tasks);
-    log_print(count($tasks));
+    foreach($old_tasks as $task) {
+        // Update parent round cache for old tasks
+        task_get_parent_rounds($task, true);
+    }
 
     if (count($tasks) > 0) {
@@ -182 +183 @@
                   VALUES ". implode(', ', $values);
         db_query($query);
+        foreach($tasks as $task) {
+            // Update parent round cache for new tasks
+            task_get_parent_rounds($task, true);
+        }
     }
 }

trunk/common/db/task.php

@@ -132 +132 @@
 
 // Returns list of round ids that include this task
-function task_get_parent_rounds($task_id) {
+function task_get_parent_rounds($task_id, $force_no_cache=false) {
     log_assert(is_task_id($task_id));
+    if (!$force_no_cache) {
+        $result = mem_cache_get("task-rounds-by-id:$task_id");
+        if ($result !== false) {
+            return $result;
+        }
+    }
+
     $query = sprintf("
         SELECT DISTINCT round_id
@@ -149 +156 @@
     }
 
+    mem_cache_set("task-rounds-by-id:$task_id", $idlist);
     return $idlist;
 }