On Friday 16 September 2005 12:47, Alan Brown wrote:
> 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.
This is surprising because I always understood that a multiple index (JobId,
PathId, FilenameId) was equivalent (actually better) than one only on JobId.
Could you tell me what DB you are using MySQL, ...? and confirm what indexes
you had before and after your change?
If simply adding a single index on JobId to the File table makes such an
amazing difference in speed, I definitely want to ensure that 1.38 is
released that way.
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
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
