]> git.sur5r.net Git - bacula/bacula/commit
projects / bacula / bacula / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ae95e93) | patch
Remove the inx4 index for SQLite2/3 (FilenameId, PathId) on
authorEric Bollengier <eric@eb.homelinux.org>
Tue, 29 Sep 2009 12:44:17 +0000 (14:44 +0200)
committerEric Bollengier <eric@eb.homelinux.org>
Tue, 29 Sep 2009 12:44:17 +0000 (14:44 +0200)
commitf159cf688fdaa6a333cc18ccb203b44663889904
tree62baa67dc106ca7f0106f722b404dbcf986f7d4btree | snapshot
parentae95e937f833ac1aef0d2bd3a82fee72e038213bcommit | diff
Remove the inx4 index for SQLite2/3 (FilenameId, PathId) on
File table. Replace it by an index over (JobId, PathId, FilenameId).

It is useless for common usage, and causes performance issues.
This index fragments over the time and the update cost grows
very quickly. (This index is not present on Mysql schema)
bacula/src/cats/make_sqlite3_tables.in diff | blob | history
bacula/src/cats/make_sqlite_tables.in diff | blob | history
Cloned from http://git.bacula.org/bacula