Hello, >> >> When you add new indexes on the File table it leads to support >> problems where people are complaining about backup speed... > > At least on this box, the CPU isn't an issue, so updating some more > indices won't hurt too much. With some old box with old spinning rust > for the databse, it might matter more, though. > > Anyway - if not adding it to the mainline, perhaps adding it to the > FAQ instead? The query time went from 15 minutes to<50ms after adding > this index...
If you want, a better solution would be to modify the query to run it in two or three times and retrieve jobids first, then pathid/filenameid, but it requires more complex code. (perhaps you can do tests on your database and report us if you have any improvements) So, if you add something to the wiki FAQ, don't forget to mention that this is not advised by the dev team, and specify for which specific restore mode this index is useful (not sure that this option is wildly used). Bye -- Need professional help and support for Bacula ? Visit http://www.baculasystems.com ------------------------------------------------------------------------------ 5 Ways to Improve & Secure Unified Communications Unified Communications promises greater efficiencies for business. UC can improve internal communications as well as offer faster, more efficient ways to interact with customers and streamline customer service. Learn more! http://www.accelacomm.com/jaw/sfnl/114/51426253/ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
