advise on saving multimedia files | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

advise on saving multimedia files

advise on saving multimedia files how can i save image or doc files to my database. for example a picture file or a document. thanks rizbon
Keep them outside, only store the file path in the database.
Adriaan is right. SQL Server, and virtually every database for that matter, does a terrible job of storing media files. —————————–
Brad M. McGehee, SQL Server MVP
Roji Thomas posted a link to a recent MS research. I can’t find it at the moment, but in essence its says that a database is superior when files are < 1MB. The file system does a better job at files > 1 MB. As I guess your files will be larger or if you need streaming media performance, go with the file system and only store a path reference in the database. —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
OK! THANK YOU SO MUCH PEOPLE! BLESSED BE! rizbon
Frank might be reffering to the following one…
http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45
MohammedU.
Moderator
SQL-Server-Performance.com
]]>