From e46fb309654b82b596a2e5613dcc1c74af4366c0 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Sat, 27 Nov 2021 14:56:22 +0100
Subject: refactor get_ready_deposits query and index to hopefully make query
 faster

---
 src/exchangedb/plugin_exchangedb_postgres.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/exchangedb/plugin_exchangedb_postgres.c')

diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c
index 2c863a32..3591470e 100644
--- a/src/exchangedb/plugin_exchangedb_postgres.c
+++ b/src/exchangedb/plugin_exchangedb_postgres.c
@@ -1105,11 +1105,11 @@ prepare_statements (struct PostgresClosure *pg)
       " WHERE "
       "       shard >= $2"
       "   AND shard <= $3"
+      "   AND wire_deadline<=$1"
+      "   AND refund_deadline<$1"
       "   AND tiny=FALSE"
       "   AND done=FALSE"
       "   AND (kyc_ok OR $4)"
-      "   AND wire_deadline<=$1"
-      "   AND refund_deadline<$1"
       " ORDER BY "
       "   shard ASC"
       "  ,wire_deadline ASC"
-- 
cgit v1.2.3