From 4a8262f5cd9d319817ae7bf7ee69fc587808b0ad Mon Sep 17 00:00:00 2001 From: schneefux Date: Sun, 5 Mar 2017 20:55:12 +0100 Subject: improve acquire query performance --- joblib.py | 1 + 1 file changed, 1 insertion(+) diff --git a/joblib.py b/joblib.py index 9e8cf84..c384e5f 100644 --- a/joblib.py +++ b/joblib.py @@ -72,6 +72,7 @@ class JobQueue(object): FROM jobs WHERE type=$1 AND status='open' ORDER BY priority DESC + LIMIT 1 """, jobtype) if result is None: # no jobs available -- cgit v1.3.1