<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7100.4129"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Calibri>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.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>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.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>So I suppose I have three questions: </FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>1) Do I have it right that the attachments are stored in
the DB itself?</FONT></DIV>
<DIV><FONT face=Calibri>2) If they are, could the DB handle, say, a
thousand 200KB-2MB attachments per year (and if so for how long?)?</FONT></DIV>
<DIV><FONT face=Calibri>3) If they aren't, is there something else that might be
a problem?</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Thanks for your help,</FONT></DIV>
<DIV><FONT face=Calibri>Mike</FONT></DIV></BODY></HTML>