Reading Large Videos from Varbinary(max) SQL2005

[Guest]

We  are storing some somewhat large (15-20MB) videos files in an SQL 2005  table within a varbinary(max) type column.  The video files are used and  displayed in our CMS web application which is written in Coldfusion.   Retrieving the videos with a standard SQL select statement through  Coldfusion is very slow. 

Does anyone know if there is a way to  speed up the retrieval of the data through Coldfusion, SQL Server, T-SQL, or a cfobject call to .NET?

I appreciate all  suggestions. 

Thanks ahead of time!

[Guest]

I'll make the suggestion but I imagine you may already have a reason you're not doing it... take the videos out of the database, put them in a specific folder (ex: /mysite/videos/ or even outside of the webroot if you want to hide them) and use a column in your database that points to the actual path/filename of the video. I believe most developers just reference media (images/videos/pdfs) by their paths in a database.

[Guest]

Just wanted to close this issue, we moved to 2008 and are using FILESTREAM. Thanks for the suggestion.