I am considering attaching .wav files of the voicemail left on our helpdesk to
rt tickets, but I'm worried about performance/stability if I start putting this
amount of binary data in the system. I ran this thought by our local DB guy and
he suggested that this might not be a problem if the database just contained
pointers to files stored elsewhere.
I looked at the rt3.Attachments and it looks like the content is actually
stored in the DB itself, but I'm a DB newbie.
So I suppose I have three questions:
1) Do I have it right that the attachments are stored in the DB itself?
2) If they are, could the DB handle, say, a thousand 200KB-2MB attachments per
year (and if so for how long?)?
3) If they aren't, is there something else that might be a problem?
Thanks for your help,
Mike
_______________________________________________
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
