On Tue, 9 Jan 2007, Dan Langille wrote: >> when I want restore files, the building directory tree is very slowly >> (several minutes) for job, wich have for example 1,372,029 JobFiles. >> >> Do you have some tip for quicklier restore(quicklier building directory >> tree). > > Searching the mailing list archives for "missing indexes", or > something like that. Perhaps someone else knows the information
Creating an index (I called it JobId) on the File table JobId,PathId,FilenameId (IN THAT ORDER!) will speed things up - a LOT. AB ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
