On Tuesday 25 October 2005 15:38, Sebastian Stark wrote: > On Tuesday 25 October 2005 15:08, Volker Sauer wrote: > > > Well, something is wrong here, you should have an index on JobId as > > follows: > > Yes, and that's the solution! The missing index on JobId make the SQL > > with "... where JobID=...." painfully slow! > > I checked the source and the debian package and this index is included > > by default. I have no idea why it's missing on my database. I'm creating > > it right now (takes some time)! > > Hi Volker, > > We're suffering from exactly the same problem. Could you describe how to > add the missing index? Can it be done while the server is running?
Okay, I figured that out: CREATE INDEX JobId ON File (JobId);. Now some figures :) Building the directory tree for a client with ~1.5 millions of files used to take hours, if not days (!) for our installation. After adding an index on the JobId to the File table it takes a couple of minutes! That's what I call speeding up things. -Sebastian -- Sebastian Stark -- http://www.kyb.tuebingen.mpg.de/~stark Max Planck Institute for Biological Cybernetics ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
