Philipp Hörist pushed to branch master at gajim / gajim
Commits: 96f9fbc2 by Philipp Hörist at 2019-11-01T09:14:07Z Database: Add index on the message_id column
- - - - -
1 changed file:
- gajim/common/logger.py
Changes:
===================================== gajim/common/logger.py ===================================== @@ -95,7 +95,8 @@ LOGS_SQL_STATEMENT = ''' ); CREATE INDEX idx_logs_jid_id_time ON logs (jid_id, time DESC); CREATE INDEX idx_logs_stanza_id ON logs (stanza_id); - PRAGMA user_version=4; + CREATE INDEX idx_logs_message_id ON logs (message_id); + PRAGMA user_version=5; '''
CACHE_SQL_STATEMENT = ''' @@ -328,6 +329,13 @@ class Logger: ] self._execute_multiple(con, statements)
+ if self._get_user_version(con) < 5: + statements = [ + 'CREATE INDEX idx_logs_message_id ON logs (message_id)', + 'PRAGMA user_version=5' + ] + self._execute_multiple(con, statements) + def _migrate_cache(self, con): if self._get_user_version(con) == 0: # All migrations from 0.16.9 until 1.0.0
View it on GitLab: https://dev.gajim.org/gajim/gajim/commit/96f9fbc25f24bbdf40fbcbe0c790f44df7d...