[taler-exchange] branch master updated: refactor get_ready_deposits query and index to hopefully make query faster

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new e46fb309 refactor get_ready_deposits query and index to hopefully make 
query faster
e46fb309 is described below

commit e46fb309654b82b596a2e5613dcc1c74af4366c0
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Sat Nov 27 14:56:22 2021 +0100

    refactor get_ready_deposits query and index to hopefully make query faster
---
 src/exchangedb/exchange-0001.sql            | 5 +++--
 src/exchangedb/plugin_exchangedb_postgres.c | 4 ++--
 2 files changed, 5 insertions(+), 4 deletions(-)

diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql
index 0426dc50..7ad0676c 100644
--- a/src/exchangedb/exchange-0001.sql
+++ b/src/exchangedb/exchange-0001.sql
@@ -418,11 +418,12 @@ COMMENT ON INDEX deposits_coin_pub_merchant_contract_index
 CREATE INDEX IF NOT EXISTS deposits_get_ready_index
   ON deposits
   (shard
+  ,wire_deadline
+  ,refund_deadline
   ,tiny
   ,done
+  ,kyc_ok
   ,extension_blocked
-  ,wire_deadline
-  ,refund_deadline
   );
 COMMENT ON INDEX deposits_coin_pub_merchant_contract_index
   IS 'for deposits_get_ready';
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"

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.