Software / code / prosody
Diff
plugins/mod_storage_sql.lua @ 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 |
| parent | 10655:ee6c12264420 |
| child | 10701:929c95e518f0 |
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);
