On Mon, Apr 9, 2012 at 4:39 PM, Julien S <jusous...@free.fr> wrote: > Do you think if I tuning databases with : > http://www.newitperson.com/2011/01/reduce-bacula-dbcheck-time/ > 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); > > Or with : > http://www.bacula.org/manuals/en/catalog/catalog/Catalog_Maintenance.html#SECTION00291000000000000000 > CREATE INDEX file_jobid_idx on file (jobid); > CREATE INDEX file_jpf_idx on file (jobid, pathid, filenameid); > > it will be faster? >
Neither of these will effect the problem you are trying to solve. John ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
