]> git.sur5r.net Git - bacula/bacula/commit
projects / bacula / bacula / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7d2d17b) | 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 13:49:29 +0000 (15:49 +0200)
commitf3f472daae4da8860968870b1c3c604de66bcf10
tree201aac156cd5f3c7412be6d0d3c219755024b912tree | snapshot
parent7d2d17bc51282523b21b2603d936edd8d89e65bfcommit | 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