exchange

commit 0c8b264dc840f22b9dc1d85b3556fc4b35d00bf7
parent ae827bec0295598d73c79b5a9976cd49a335174e
Author: Christian Grothoff <grothoff@gnunet.org>
Date:   Tue, 17 Oct 2023 12:18:37 +0200

use new 'was_decided' field instead of expensive subquery

Diffstat:
M
src/exchangedb/exchange_do_expire_purse.sql
 | 
7
+++----

1 file changed, 3 insertions(+), 4 deletions(-)
diff --git a/src/exchangedb/exchange_do_expire_purse.sql b/src/exchangedb/exchange_do_expire_purse.sql
@@ -35,12 +35,11 @@ SELECT purse_pub
       ,in_reserve_quota
   INTO my_purse_pub
       ,my_in_reserve_quota
-  FROM exchange.purse_requests
+  FROM purse_requests
  WHERE (purse_expiration >= in_start_time) AND
        (purse_expiration < in_end_time) AND
-   purse_pub NOT IN (SELECT purse_pub
-                       FROM purse_decision)
- ORDER BY purse_expiration ASC
+       NOT was_decided
+  ORDER BY purse_expiration ASC
  LIMIT 1;
 out_found = FOUND;
 IF NOT FOUND