summary refs log tree commit diff
path: root/synapse/storage/schema/transactions.sql
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-01-06 15:40:38 +0000
committerErik Johnston <erik@matrix.org>2015-01-06 15:40:38 +0000
commitf6da237c353d598946a6c81260653203602800c2 (patch)
tree36c8fb11f4f48932e307663c09eedb8deff617e8 /synapse/storage/schema/transactions.sql
parentActually time that function (diff)
downloadsynapse-f6da237c353d598946a6c81260653203602800c2.tar.xz
Add index on transaction_id to sent_transcations
Diffstat (limited to 'synapse/storage/schema/transactions.sql')
-rw-r--r--synapse/storage/schema/transactions.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/synapse/storage/schema/transactions.sql b/synapse/storage/schema/transactions.sql
index 86f530d82a..2d30f99b06 100644
--- a/synapse/storage/schema/transactions.sql
+++ b/synapse/storage/schema/transactions.sql
@@ -42,6 +42,7 @@ CREATE INDEX IF NOT EXISTS sent_transaction_dest ON sent_transactions(destinatio
 CREATE INDEX IF NOT EXISTS sent_transaction_dest_referenced ON sent_transactions(
     destination
 );
+CREATE INDEX IF NOT EXISTS sent_transaction_txn_id ON sent_transactions(transaction_id);
 -- So that we can do an efficient look up of all transactions that have yet to be successfully
 -- sent.
 CREATE INDEX IF NOT EXISTS sent_transaction_sent ON sent_transactions(response_code);