Hello, Here is my Pb when I restored (rest -> choice 5), building tree is 15 minutes to build.
How do I know what is the SQL generated? and / or What indexes should it position? I was bacula 2.4.4 but in recent days 3.0.2. The only upgrade_mysql_table not what to put as indexes. was the creation from scratch, the indexes are different if one starts with a old version. Zero: File table = FileId, JobId, JobId+PathId+FilenameId (Which was generated in keyname JobId_2) Since v2.4.4 -> 3.0.2: File table = FileId, JobId+PathId+FilenameId Besides the official documentation ( http://bacula.org/3.0.x-manuals/en/catalog/catalog/Catalog_Maintenance.html), he speaks CREATE INDEX file_jpf_idx on File (JobId, FilenameId, PathId); column order is reversed between FilenameId and PathId is it important Thank you for your help Best regards Olivier ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
