Solved

Large files

Posted on 2013-11-02
2
269 Views
Last Modified: 2013-11-03
we need to store large files in our project. we will be using sql server 2012. For each user we will be assigning 1GB space and per file 200MB limit.

What would be the better approach is it save the files in the file disk or SQL server please advice.
0
Comment
Question by:bvs_reddy
2 Comments
 

Accepted Solution

by:
noodles_esa earned 25 total points
ID: 39619564
this strongly depends on what Kind of files you use and what you want to do with the files. If you want them to be indexed (as far as they can be indexed) and the Content to be searchable, then it would be better to store them in the db. if you are just using them as a user store then the filesystem would be the better way i guess.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39619598
The file system is usually better because you keep the file assocations so they can be opened appropriately.  If you store them in the database, you generally have to re-save them as files with the correct name and extension so that they can be opened correctly.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
backup and restore 21 30
Location of Dynamics AX Service accounts in SQL 3 16
SQL Availablity Groups Shared Path 2 16
Loops in SQL server code 4 21
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question