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!
My suggestion is to store the physical PATH for the video in the database, but keep the video itself OUTSIDE the database.
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.
FILESTREAM works pretty good in 2008.