Sounds scary. We should probably cook up an interface for doing bulk deletes/re replicates/checks via the tracker, somewhat safely.
Yes, on some level I believe it would work if you selected the fids into file_to_delete. It could still take a while, but you could also add a few extra delete jobs. I'd be paranoid enough to stop the trackers while doing the bulk load into file_to_delete... Not sure offhand if doing a delete through a tracker ensures you're not doing anything awful if a fid is locked by another process. -Dormando Clinton Goudie-Nice wrote: > I'm looking for some quick sql to delete the entire list of files in my > mogile store. Can I just do a select into files_to_delete from file? > > In my bulk testing, I often fill up the store with garbage, and I'd > rather tear it down this way than have to issue all the delete commands > through the tracker; through the tracker it just takes too long. > > Thanks! > > Clint > > > Twelve Horses <http://web.twelvehorses.com/> Mobile > <http://web.twelvehorses.com/info_center/whitepaper/> Social > <http://web.twelvehorses.com/solutions/blogging_for_business/> Web > <http://web.twelvehorses.com/solutions/website_design/> Email > <http://web.twelvehorses.com/technology/> > > > *Clinton Goudie-Nice* > Architect / Senior Software Engineer > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Phone: +1.801.571.2665 ext 3264 > Mobile: +1.801.915.0629 > Fax: +1.801.571.2669 > LinkedIn: http://www.linkedin.com/in/cgoudie > > > *Twelve Horses* > 13961 Minuteman Drive > Suite 125 > Draper, UT 84020 > *www.twelvehorses.com <http://www.twelvehorses.com>* > > > > >
