On Sat, Jan 28, 2006 at 09:48:11AM -0600, Jeffrey L. Taylor wrote:
> I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and
> Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I
> killed the orphaned path check after 2 days.
Out of curiosity, how many rows do you have in these two tables?
select count(*) from File;
select count(*) from Job;
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
