<div dir="ltr"><div class="gmail_quote">On Mon, May 2, 2011 at 9:45 PM, C F <span dir="ltr"><<a href="mailto:shmaltz@gmail.com">shmaltz@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Just from my experience with different DBs, stay away from BLOB data<br>
types as much as possible.<br>
<div><div></div><div class="h5"><br></div></div></blockquote><div><font class="Apple-style-span" face="'trebuchet ms', sans-serif" color="#663366">Hi CF,</font></div><div><font class="Apple-style-span" face="'trebuchet ms', sans-serif" color="#663366">any particular reason why? I've had a good experience with it, in fact that's recommended by DB developers when it's a case of small files. They say only larger files greater than 500K-1MB should be stored on the filesystem using filestream or similar etc.</font></div>
<div><font class="Apple-style-span" face="'trebuchet ms', sans-serif" color="#663366"><br></font></div><div><font class="Apple-style-span" face="'trebuchet ms', sans-serif" color="#663366">Although at this point, this might be a moot point, as so far no one's been able to suggest a way to be able to stream the content of the BLOB field to Asterisk over the AGI connection into the current channel, such that Asterisk can just play it on the fly. We'll have to just go with getting the file to the requesting * server and then play it</font></div>
<div><br></div><div><br></div></div></div>