diff options
| author | Holger Weiss <holger@zedat.fu-berlin.de> | 2018-02-24 00:50:20 +0100 |
|---|---|---|
| committer | Holger Weiss <holger@zedat.fu-berlin.de> | 2018-02-24 00:50:20 +0100 |
| commit | f7566bd00e687df60fd470b9fdfc5ce6b04f0c7c (patch) | |
| tree | 699db516e8fbdcdf11d998fe57e9aaa3ced0a078 /sql/mysql.sql | |
| parent | Merge pull request #2297 from af8a524db1/move_make_rand_string (diff) | |
sql/*: Add username to peer indexes
The username is available for all MAM queries in question, and adding it
to the indexes can improve the lookup performance significantly.
Diffstat (limited to 'sql/mysql.sql')
| -rw-r--r-- | sql/mysql.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index 3e34bbb3..64d26fa8 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -102,10 +102,10 @@ CREATE TABLE archive ( ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE FULLTEXT INDEX i_text ON archive(txt); -CREATE INDEX i_username_timestamp USING BTREE ON archive(username,timestamp); +CREATE INDEX i_username_timestamp USING BTREE ON archive(username, timestamp); +CREATE INDEX i_username_peer USING BTREE ON archive(username, peer); +CREATE INDEX i_username_bare_peer USING BTREE ON archive(username, bare_peer); CREATE INDEX i_timestamp USING BTREE ON archive(timestamp); -CREATE INDEX i_peer USING BTREE ON archive(peer); -CREATE INDEX i_bare_peer USING BTREE ON archive(bare_peer); CREATE TABLE archive_prefs ( username varchar(191) NOT NULL PRIMARY KEY, |