Software / code / prosody
Changeset
10700:3fce670e0733 0.11
mod_storage_sql: Add index covering sort_id to improve performance (fixes #1505)
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Sun, 22 Mar 2020 21:05:59 +0100 |
| parents | 10699:fd77b6cec38d |
| children | 10701:929c95e518f0 10703:6b63ba5b078a |
| files | plugins/mod_storage_sql.lua |
| diffstat | 1 files changed, 1 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/plugins/mod_storage_sql.lua Sun Mar 22 17:35:26 2020 +0100 +++ b/plugins/mod_storage_sql.lua Sun Mar 22 21:05:59 2020 +0100 @@ -500,6 +500,7 @@ Index { name="prosodyarchive_index", unique = engine.params.driver ~= "MySQL", "host", "user", "store", "key" }; Index { name="prosodyarchive_with_when", "host", "user", "store", "with", "when" }; Index { name="prosodyarchive_when", "host", "user", "store", "when" }; + Index { name="prosodyarchive_sort", "host", "user", "store", "sort_id" }; }; engine:transaction(function() ProsodyArchiveTable:create(engine);
