BACULA – How To reduce DbCheck Time

I added the following indexes:

CREATE INDEX File_JobId_idx ON File(JobId);
CREATE INDEX File_PathId_idx ON File(PathId);
CREATE INDEX File_FilenameId_idx ON File(FilenameId);
CREATE INDEX Path_PathId_idx ON Path(PathId);
CREATE INDEX Job_FileSetId_idx ON Job(FileSetId);
CREATE INDEX Job_ClientId_idx ON Job(ClientId);
CREATE INDEX File_FilenameIdPathId_idx ON File(FilenameId,PathId);

This reduced dbcheck time from >24 hours to a few *seconds*. Adding the
indexes themselves only took up to 15 seconds.