bareos: master 6af83db6

Diff Back to Repository
Author Committer Branch Timestamp Parent
stephand stephand master 2016-05-12 20:25 master ed63c7e0 Pending
Changeset Denormalized Filename Table

- For increased DB performance, the File and Filename tables were
  denormalized, that means the Name column of the Filename table is now
  in the File table. Thus when inserting from the batch table, joins
  with the Filename table are no longer necesary. Also no more exclusive
  locking of the Filename table which allow parallization.
- The changes were made for PostgreSQL, MySQL and SQLite, but most
  testing has been done with PostgreSQL. However, regressions should
  work for all DBs.
- TODO:
  - The DB version string is still 2004, it must be changed to
    distinguish from current 16.2 with non-normalized DB structure.
  - The DB update script must be adapted to do the denormalization.
mod - po/bareos.pot Diff File
mod - po/de.po Diff File
mod - po/es.po Diff File
mod - po/fr.po Diff File
mod - po/it.po Diff File
mod - po/nl.po Diff File
mod - po/pl.po Diff File
mod - po/sv.po Diff File
mod - po/uk.po Diff File
mod - src/cats/bvfs.c Diff File
mod - src/cats/bvfs.h Diff File
mod - src/cats/cats.h Diff File
mod - src/cats/ddl/creates/ingres.sql Diff File
mod - src/cats/ddl/creates/mysql.sql Diff File
mod - src/cats/ddl/creates/postgresql.sql Diff File
mod - src/cats/ddl/creates/sqlite3.sql Diff File
mod - src/cats/ddl/drops/postgresql.sql Diff File
mod - src/cats/ddl/grants/postgresql.sql Diff File
mod - src/cats/sql_cmds.c Diff File
mod - src/cats/sql_create.c Diff File
mod - src/cats/sql_get.c Diff File
mod - src/cats/sql_list.c Diff File
mod - src/dird/fd_cmds.c Diff File
mod - src/dird/migrate.c Diff File
mod - src/dird/query.sql Diff File
mod - src/dird/ua_cmds.c Diff File
mod - src/dird/ua_dotcmds.c Diff File
mod - src/dird/verify.c Diff File
mod - src/tests/bvfs_test.c Diff File