diff options
| author | Christian Grothoff <grothoff@gnunet.org> | 2023-10-17 12:18:37 +0200 |
|---|---|---|
| committer | Christian Grothoff <grothoff@gnunet.org> | 2023-10-17 12:18:37 +0200 |
| commit | 0c8b264dc840f22b9dc1d85b3556fc4b35d00bf7 (patch) | |
| tree | 5037105d8c927694be5b33189863a9902111ca73 | |
| parent | ae827bec0295598d73c79b5a9976cd49a335174e (diff) | |
| download | exchange-0c8b264dc840f22b9dc1d85b3556fc4b35d00bf7.tar.xz | |
use new 'was_decided' field instead of expensive subquery
| -rw-r--r-- | src/exchangedb/exchange_do_expire_purse.sql | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/exchangedb/exchange_do_expire_purse.sql b/src/exchangedb/exchange_do_expire_purse.sql index 2d9f7e095..1a17869ad 100644 --- 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 |