Using a MySQL client, it's fairly easy to move large RT attachments to another location and replace them with "This file can be found at ftp://fileserver.mycompany.com/queuename/attachmentid";.
Large attachments clutter MySQL and slow down full text searching and other operations (they *shouldn't* [because RT uses lots of INDEXes, etc], but they do-- not sure why). Can I "strip" attachments in real time? Write some sort of "hook" that runs just before an email is INSERTed into the MySQL tables? Stripping attachments via cron is a big kludgey (especially since I have to do "OPTIMIZE TABLE" each time). -- We're just a Bunch Of Regular Guys, a collective group that's trying to understand and assimilate technology. We feel that resistance to new ideas and technology is unwise and ultimately futile. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
