[asterisk-users] Retrieving sound files from DB as opposed to filesystem

[Tzafrir Cohen]

On Tue, May 03, 2011 at 07:26:25AM -0400, A E [Gmail] wrote:

> yes, after having noodled with this for a while, it appears that the best
> way would be to somehow replicate what the Realtime Voicemail does but just
> not bother storing the media files in the DB. Extracting the BLOB data,
> storing it as a temp file and playing it Voicemail used to work fairly well
> with no perceivable latency, so I'm hoping not having to pick up the file
> from the DB but directly from the filesystem and copying it over to the {*}
> machine should be slightly faster. I doubt though, anything useful will be
> in the cache as we don't expect the same files to be accessed too often but
> then again, you never know. BTW, does that happen by default or do I need to
> set this up via memcached and stuff like that?

Note: by using a temporary file, as opposed to a permanent local file,
you get much less file-system caching. If you expect the same files to
be played many times, this is a waste of I/O. Though with some luck
you'll always still have the temporary files in the cache.

-- 
               Tzafrir Cohen
icq#16849755              jabber:tzafrir.cohen at xorcom.com
+972-50-7952406           mailto:tzafrir.cohen at xorcom.com
http://www.xorcom.com  iax:guest at local.xorcom.com/tzafrir