Referencing files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!).
 
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.
 
Thank you!

Robbe Morris said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 0
Should heavy binary files not be stored in database? 1
How can I migrate MBOX to PST? 2
Best tool to recover PST files in 2026 0
How to change default sql server? 4
Access Print Files from Query Results 0
User information DB 1

Back
Top