On Thu, 15 Sep 2005, Daniel Weuthen wrote:

I had the same problems with Jobs which have more than 680000 files and mysql
as database. After putting an index on JobId in the File table I got an
enormous speed up:

I just tried this and the speedup is amazing. Getting to selection of individual old files for a user now takes less than 5 minutes, vs more than an hour previously.



-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to