Hi Shaun, AFAIK this is the only one which should really be used in the default installation. I don't know about other Indices.
Roland -----Urspr�ngliche Nachricht----- Von: Shaun T. Erickson [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 11. M�rz 2005 16:37 An: [email protected] Betreff: Re: AW: [Bacula-users] Building directory tree takes hours Roland Arendes wrote: > Hi, > > Yes, Database Indices. They are missing on purpose, according to Kern > - everyone has different database needs. > I don't agree with him in this special point, but that's my opinion. > This should speed up the tree building drastically: > > mysql > >>use bacula; >>ALTER TABLE File ADD INDEX (JobId, PathId, FilenameId); Perhaps, for those of us who know zero about databases, bacula should create a default set of indices that would serve the greatest number of people, allowing those who know more and whose needs are different, to alter them if they wish. Aside from the one above, are there any other indices that should be created, which would speed up bacula's performance? Thanks. -ste ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
