Reading Large Videos from Varbinary(max) SQL 2005

[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!

[tclaremont]

My suggestion is to store the physical PATH for the video in the database, but keep the video itself OUTSIDE the database.

[Guest]

@tclaremont

Thanks for the reply.  Ive decided to go the file system route as you were suggesting below.  Seems like the only real answer until we upgrade to SQL 2008, which has the FILESTREAM data type.

[Guest]

FILESTREAM works pretty good in 2008.