]> git.sur5r.net Git - bacula/bacula/commit
projects / bacula / bacula / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 216767f) | 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)
commite71db11c224311ad2ee46cb4a60a9b0603cb8fcf
treee21bc9d2e4d3c0f5edcb518f2ce45f3057b88086tree | snapshot
parent216767fd8550b1a03b392e6b3f78ca55521eb1a7commit | 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