[Bacula-users] bconsole slow

Hi Bacula Users,

bconsole during copyjobs is very slow, it becomes frozen for 10-15 minuts maybe bacause of this query on mysql 5.1.44:

SELECT DISTINCT DelCandidates.JobId,DelCandidates.PurgedFiles FROM Job,DelCandidates WHERE (Job.JobId=DelCandidates.JobId AND DelCandidates.JobStatus NOT IN ('T','W')) OR (Job.JobTDate>1262847609 AND Job.ClientId=12 AND Job.Type='C')

ClientId 12 is the client for copyjobs.

Is there a suggested configuration for this issue?

Thank you.

Best regards.

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share 
of $1 Million in cash or HP Products. Visit us here for more details:
http://ad.doubleclick.net/clk;226879339;13503038;l?
http://clk.atdmt.com/CRS/go/247765532/direct/01/

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users