Hi Michael,
Like Jesse mentioned, 200MB-2GB is really not terribly large and
should be easily handled by most current DBs. Oracle, PostgreSQL,
and MySQL definitely can. One thing to consider is if your users
will be running a content search within the attachments. This will
require a full scan of
On Jul 29, 2009, at 4:16 PM, Michael Ellis wrote:
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
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
1) Do I have it right that the attachments are stored in the DB itself?
Alas, they are.
2) If they are, could the DB handle, say, a thousand 200KB-2MB attachments
per year (and if so for how long?)?
Depends on your rdbms. Oracle could it, not so sure about MySQL.
Alternatively, you could
On Wed 29.Jul'09 at 18:16:51 -0500, Michael Ellis wrote:
So I suppose I have three questions:
1) Do I have it right that the attachments are stored in the DB itself?
Yes.
2) If they are, could the DB handle, say, a thousand 200KB-2MB attachments per
year (and if so for how long?)?
2