On Friday 01 April 2011 22:00:17 Bob Hetzel wrote: > Hi Kern, > > I'm 100% sure I've checked for extra indexes on the File table in the past > but now I checked again and then dropped the index I had on PathId in the > File table. > > The time to build the build the restore tree is again manageable now for a > test case I had run earlier today and also for a different client specified > just to be sure it wasn't improved due to database/disk caching. > > The index was named idxPIchk which I don't think I would have come up with > on my own, so I'm not sure where it came from. Is that the name dbcheck > uses to create the index that's supposed to be temporary? >
Yes. I suppose dbcheck either died or was killed, so it never got a chance to remove the index. ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
