[taler-exchange] branch master updated: -try to optimize query

[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 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.