Changeset 960 for trunk/common

Timestamp:

11/20/08 23:32:07 (4 years ago)

Author:

bogdan2412

Message:

Optimize job_get_next_job

Reviewed ​http://reviewboard.infoarena.ro/r/39

File:

• trunk/common/db/job.php (modified) (1 diff)

trunk/common/db/job.php

@@ -42 +42 @@
        `job`.`eval_message`, `job`.`score`, `job`.`file_contents`
     FROM `ia_job` AS `job`
-    WHERE (`status` != 'done')
-    ORDER BY `submit_time` ASC LIMIT 1
+    WHERE `job`.`id` = (
+        SELECT MIN(id)
+        FROM `ia_job`
+        WHERE (`status` IN ('waiting', 'proceessing'))
+    )
 SQL;
     return db_fetch($query);