From 5c3fdc3ee1635b06a4136e7accc0a7f360840e92 Mon Sep 17 00:00:00 2001
From: Angie Byron <webchick@24967.no-reply.drupal.org>
Date: Wed, 1 Dec 2010 00:21:02 +0000
Subject: #985184 by Steven Jones: Fix brain-o in Batch query causing bad
 performance on large tables.

---
 includes/batch.queue.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'includes/batch.queue.inc')

diff --git a/includes/batch.queue.inc b/includes/batch.queue.inc
index 8193280f3..ee721463f 100644
--- a/includes/batch.queue.inc
+++ b/includes/batch.queue.inc
@@ -21,7 +21,7 @@
 class BatchQueue extends SystemQueue {
 
   public function claimItem($lease_time = 0) {
-    $item = db_query('SELECT data, item_id FROM {queue} q WHERE name = :name ORDER BY item_id ASC', array(':name' => $this->name))->fetchObject();
+    $item = db_query_range('SELECT data, item_id FROM {queue} q WHERE name = :name ORDER BY item_id ASC', 0, 1, array(':name' => $this->name))->fetchObject();
     if ($item) {
       $item->data = unserialize($item->data);
       return $item;
-- 
cgit v1.2.3