[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-exchange] branch master updated: refactor get_ready_deposits quer
From: |
gnunet |
Subject: |
[taler-exchange] branch master updated: refactor get_ready_deposits query and index to hopefully make query faster |
Date: |
Sat, 27 Nov 2021 14:56:30 +0100 |
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.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [taler-exchange] branch master updated: refactor get_ready_deposits query and index to hopefully make query faster,
gnunet <=