Skip to main content
July 1, 2010
Question

Reading Large Videos from Varbinary(max) SQL 2005

  • July 1, 2010
  • 1 reply
  • 1141 views

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!

This topic has been closed for replies.

1 reply

tclaremont
Inspiring
July 1, 2010

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

July 1, 2010

@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.

March 24, 2011

FILESTREAM works pretty good in 2008.