Skip to main content
A
Anonymous
July 1, 2010
Question

Reading Large Videos from Varbinary(max) SQL2005

  • July 1, 2010
  • 2 replies
  • 724 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.

2 replies

A
Anonymous
March 24, 2011

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

A
Anonymous
July 8, 2010

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices