Depends... If you are envision your site being moved into
a web farm, then the database is it. If you are absolutely
certain this will "never" happen, then storing the file
location is going to be much better from a performance
perspective.
--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp
"R Riness" <rr*****@nospam.att.net> wrote in message
news:B5**********************************@microsof t.com...
I'm building my first ASP.Net site, and wonder about the best way to
reference data in files. Should I store documents in SQL Server, and
provide
the file from there, or store a string providing the file location in SQL
Server and include a folder with files on the web site? Thanks for your
help
(happy new years!).