My database has grown huge because our clients seem to feel it is
important they us pictures to our ticket system. Although we have only
27K tickets, the database is 1.7 GB and the time to display a ticket has
become in excess of five seconds. I don't need any of these attachments,
is there I reason not to run this on the database?
UPDATE Attachments SET Content ="";
--
Chris Mason
(264) 497-5670 Fax: (264) 497-8463
Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271
Cell: 264-235-5670
Yahoo IM: [EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
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
