Our RT is cluttered with large attachments, slowing down the MySQL engine. Our hack fix: move these attachments to a webserver and do this on the Attachments table:
UPDATE Attachments SET Content = '<META http-equiv="refresh" content="0;URL=ourserver.com/queuename/attachmentid/original_filename.original_\ extension">', ContentType='text/html' WHERE id = attachmentid; for large attachments. This helps, but is there a better solution? -- 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