Yes, I agree. There are times when the version browser is just way to
slow. The reason has to do with the kind of indexes that can be put on
the file table and it depends on the optimization mysql or postgresql or
whichever database you are using decides to optimize the query. If the
optimizer decides to do a sequential scan and you have a large table,
there is nothing you can do.
The best way to keep it fast is to keep the number of jobs select to a
low number, like 5 or 7 for the first query. Then If you decide that
you need to go back further, then make the number larger and live with
the fact that it will take some time.
All aplologies for the inconvenience. This interface is intended to
show versions available and sometimes has this not so wonderful
disadvantage. Without changing the database schemas which has been
discussed on the devel list, there is not much to be done.
I'm assuming the index you added is the one from the online help??
Dirk
On Tue, 2008-05-27 at 10:46 +0200, Daniel Ruiz Molina wrote:
> Hi,
>
> When I run "Version Browser" from "bat", Bacula takes a lot of time
> for
> give me the file list. Is there any way for making it faster?
>
> What I can see in console are messages like these (one for each file
> saved...):
> -.......-
> bat: console/console.cpp:623
> got:
> /home/alvaro/charm-5.9-net-linux-tcp/net-linux/tmp/libs/conv-libs/packlib/
> 9434
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/net-linux/tmp/libs/other/
> 9436
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/ 9033
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/CVS/ 8702
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/
> 8704
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/CVS/
> 8703
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/doc/
> 8706
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/doc/CVS/
> 8705
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/md/
> 8708
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/md/CVS/
> 8707
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/mkfiles/
> 8710
> bat: console/console.cpp:623
> got:
> /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/mkfiles/CVS/ 8709
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/time/
> 8712
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/QuickThreads/time/CVS/
> 8711
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/
> 8714
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/CVS/
> 8713
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/common/
> 8716
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/common/CVS/
> 8715
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/elan-axp/
> 8720
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/elan-axp/CVS/
> 8719
> bat: console/console.cpp:623
> got: /home/alvaro/charm-5.9-net-linux-tcp/src/arch/elan-linux-ia64/
> 87
> -.....-
>
> I have also created indexes into mysql, but system continues very slow
> when executes "Version Browser":
> CREATE INDEX file_filenameid_jobid ON File (FilenameId, JobId);
> CREATE INDEX file_pathid_idx ON File (PathId);
>
> Help!!
>
>
> Thanks.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
