[rt-users] Performance issues - deleting attachments?

[Barry Byrne]

Apologies for replying to my own message, but I managed to delete my actual
question and send the mail without my main question which was:

Does anyone know how to delete some/all attachments from a ticket. I know RT
doesn't provide a way, but I'd be happy to run the SQL queries to remove
them if I was more confident in what exactly needed to be done? Has anyone
successfully tried this?

 - Thanks,

   Barry
> Hi:
>
> Using RT 3.0.4 here and having a lot of performance issues, particularly
> where large attachments are included in a transaction. I'm getting
> frustrated users who are seing 45 second response times to
> viewing a ticket
> which has multiple attachments (perhaps a few MB in total), as opposed to
> three second times for other tickets.
>
>
> I've added indexes for all fields in the Attachment table except
> headers and
> content, and this appears to have helped matters a little,
> however it would
> seem to my mind, that keeping all email content parts
> (attachments and body
> text) in the one table is very ineffecient, as the entire table
> needs to be
> scanned including potentially many MBs or GBs of attachment data that
> doesn't need to shown. Would it not make more sense to move (actual)
> attachment to a separate table from non-attachments? Or perhaps even more
> usefully, store attachments at file level rather than in the DB.
> Apologies,
> if I'm totally off base with this the frustration levels are high!
>
> In some tickets, I've ended up with the same attachement six or
> seven times,
> since the system ran out of swap during the attachment submission, and
> sendmail temp failed the mail, but RT managed to insert the
> attachment, and
> then sendmail tried again a while later - going round in circles!
>
> --
> Barry Byrne, IT Manager,
> WBT Systems, Block 2, Harcourt Centre
> Harcourt Street, Dublin 2, Ireland
>
> Phone:  +353 1 417 0150
> Fax:    +353 1 478 5544
> Email:  barry.byrne at wbtsystems.com
> Web:    www.wbtsystems.com
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm