[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-exchange] branch master updated: -try to optimize query
From: |
gnunet |
Subject: |
[taler-exchange] branch master updated: -try to optimize query |
Date: |
Thu, 11 Nov 2021 14:17:57 +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 3c8420a1 -try to optimize query
3c8420a1 is described below
commit 3c8420a15a0118597328e7da8f1960bda5ea2567
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Thu Nov 11 14:17:54 2021 +0100
-try to optimize query
---
src/exchangedb/exchange-0002.sql | 3 ---
src/exchangedb/plugin_exchangedb_postgres.c | 14 +++++++-------
2 files changed, 7 insertions(+), 10 deletions(-)
diff --git a/src/exchangedb/exchange-0002.sql b/src/exchangedb/exchange-0002.sql
index b312e2d5..fef5fa64 100644
--- a/src/exchangedb/exchange-0002.sql
+++ b/src/exchangedb/exchange-0002.sql
@@ -323,9 +323,6 @@ ALTER TABLE refresh_revealed_coins
COMMENT ON COLUMN refresh_revealed_coins.melt_serial_id
IS 'Identifies the refresh commitment (rc) of the operation.';
-CREATE INDEX IF NOT EXISTS refresh_revealed_coins_pk_idx
- ON refresh_revealed_coins
- (melt_serial_id, freshcoin_index);
-- Change 'merchant_pub' and 'h_contract_terms' and 'known_coin_id' in
'refunds' table
diff --git a/src/exchangedb/plugin_exchangedb_postgres.c
b/src/exchangedb/plugin_exchangedb_postgres.c
index 4b3ae19d..b35e2a4f 100644
--- a/src/exchangedb/plugin_exchangedb_postgres.c
+++ b/src/exchangedb/plugin_exchangedb_postgres.c
@@ -802,16 +802,16 @@ prepare_statements (struct PostgresClosure *pg)
operation, used in #postgres_get_refresh_reveal() */
GNUNET_PQ_make_prepare ("get_refresh_revealed_coins",
"SELECT "
- " freshcoin_index"
+ " rrc.freshcoin_index"
",denom.denom_pub"
- ",link_sig"
- ",coin_ev"
- ",ev_sig"
- " FROM refresh_revealed_coins"
+ ",rrc.link_sig"
+ ",rrc.coin_ev"
+ ",rrc.ev_sig"
+ " FROM refresh_commitments"
+ " JOIN refresh_revealed_coins rrc"
+ " USING (melt_serial_id)"
" JOIN denominations denom "
" USING (denominations_serial)"
- " JOIN refresh_commitments"
- " USING (melt_serial_id)"
" WHERE rc=$1"
" ORDER BY freshcoin_index ASC;",
1),
--
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: -try to optimize query,
gnunet <=