On Mon, Apr 9, 2012 at 4:39 PM, Julien S <jusouschi AT free DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users