[Bacula-users] Which index to the mysql database?

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&reg; 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&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users