On Fri, Sep 16, 2011 at 5:48 PM, Kevin Falcone <[email protected]>wrote:
> On Fri, Sep 16, 2011 at 05:12:48PM +0300, Michael Stepanov wrote: > > Our RT3 system has Attachments table with size about 300GB. We'd like > to clean it by removing > > old records with files. The rt-shreder can do this job properly I > guess. But there is no way > > to specify query criteria there. Even direct delete query is failed. > > rt-shredder allows query criteria. > I tried rt-shreder from 3.8.2 and it accepts only files_only, file and longer. No query. > > -kevin > > > Does somebody can suggest how to clean Attachments table? > > > > BTW, IMHO it's bad idea to store files in the database cause it isn't > scalable solution and > > it's very difficult to upgrade/backup/restore DB. > > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Chicago, IL, USA — September 26 & 27, 2011 > * San Francisco, CA, USA — October 18 & 19, 2011 > * Washington DC, USA — October 31 & November 1, 2011 > * Melbourne VIC, Australia — November 28 & 29, 2011 > * Barcelona, Spain — November 28 & 29, 2011 > -- Cheers, Michael
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
