3 Replies Latest reply on Mar 24, 2011 8:20 AM by dujsu

    Reading Large Videos from Varbinary(max) SQL 2005

    dujsu Level 1

      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!