[Asterisk-Users] Asterisk & MySQL Blobs

[Steven Critchfield]

On Mon, 2005-03-07 at 16:06 -0500, Eric wrote:
> Hi Vinko,
> 
> MySQL blobs will store binary data, so you should be OK there.  I'd
> focus on whether or not storing the data in a variable is a good idea.
> Typically, with any programming language, it's good practice to
> keep variable lengths short so you aren't passing the variable itself
> between functions.  I can't say if that could cause performance issues
> under higher load.
> 
> I'd love to hear how you make out, as well as anyone else's input.

With as much as I despise the idea of the audio being stored in a DB
much less MySQL, it shouldn't be much different from it being in NFS as
long as MySQL can keep pace.

Ideally you would stream the results up fom the MySQL driver and read
the appropriate chunk size and send it through asterisk. The downside is
the need to essentially rewrite formats/* to deal with whatever file
formats you want to store in the DB or be incomplete.
-- 
Steven Critchfield <critch at basesys.com>