Hello,
What is the suggested way to store uploaded files?
1) IMAGE type data in an SQL Database table
2) As a file in the NTFS file system
Thanks,
Arsen 9 2021
2
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Arsen V." <ar***@community.nospam> wrote in message
news:O6**************@TK2MSFTNGP12.phx.gbl... Hello,
What is the suggested way to store uploaded files?
1) IMAGE type data in an SQL Database table
2) As a file in the NTFS file system
Thanks, Arsen
You really have to take the rest of your application and environment
specifics into consideration, but as a general rule of thumb I try to
avoid keeping images in database tables.
--
Scott http://www.OdeToCode.com/blogs/scott/
On Thu, 10 Feb 2005 15:37:17 -0600, "Arsen V."
<ar***@community.nospam> wrote: Hello,
What is the suggested way to store uploaded files?
1) IMAGE type data in an SQL Database table
2) As a file in the NTFS file system
Thanks, Arsen
file
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"Arsen V." <ar***@community.nospam> wrote in message
news:O6**************@TK2MSFTNGP12.phx.gbl... Hello,
What is the suggested way to store uploaded files?
1) IMAGE type data in an SQL Database table
2) As a file in the NTFS file system
Thanks, Arsen
arsen,
it' really hard to say, it depends.. just a few pointers:
- if you store files in the db, you get integrated security, backup&restore,
integrity; and you can put them on different filegroup for easier
manipulation
- if you store them in file system, file pointers (kept in the db) and files
might get out of sync, security has to be managed separately, as well as
backups. and if there's really a lot of files in a folder, file system might
get 'confused'..
dean
"Arsen V." <ar***@community.nospam> wrote in message
news:O6**************@TK2MSFTNGP12.phx.gbl... Hello,
What is the suggested way to store uploaded files?
1) IMAGE type data in an SQL Database table
2) As a file in the NTFS file system
Thanks, Arsen
A lot of people tend to jump to the conclusion that it's better to store
files in the file system.
But I say that's not always the best choice, and here are my reasons why,
along with detailed code samples to help you: http://SteveOrr.net/articles/EasyUploads.aspx
--
I hope this helps,
Steve C. Orr, MCSD, MVP http://SteveOrr.net
"Arsen V." <ar***@community.nospam> wrote in message
news:O6**************@TK2MSFTNGP12.phx.gbl... Hello,
What is the suggested way to store uploaded files?
1) IMAGE type data in an SQL Database table
2) As a file in the NTFS file system
Thanks, Arsen
Steve thanks for the info!
After reading ur article saying:-
"Next version of Windows (codenamed Longhorn) reportedly will replace
the NTFS file system with a new one (named WinFS) based on SQL Server.
So in the future, you'll be saving all your files in a database whether
you want to or not."
So what you are saying is that we won't be able to call files from FILE
SYSTEM at all in the future?
Only from the database.
About if it comes to LARGE files becos i agree with you that smaller
files can me saved in the Database.
Patrick
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Yes, although WinFS has been repeatedly delayed since I wrote that article,
it remains the holy grail for which Microsoft strives.
Clearly Microsoft sees SQL Server as the future of all file storage, so why
not start now? http://SteveOrr.net/articles/EasyUploads.aspx
--
I hope this helps,
Steve C. Orr, MCSD, MVP http://SteveOrr.net
"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:eR**************@TK2MSFTNGP12.phx.gbl... Steve thanks for the info! After reading ur article saying:-
"Next version of Windows (codenamed Longhorn) reportedly will replace the NTFS file system with a new one (named WinFS) based on SQL Server. So in the future, you'll be saving all your files in a database whether you want to or not."
So what you are saying is that we won't be able to call files from FILE SYSTEM at all in the future? Only from the database. About if it comes to LARGE files becos i agree with you that smaller files can me saved in the Database. Patrick *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Thats true Steve but.
But i think according to what i read here at:- http://msdn.microsoft.com/data/winfs...brary/en-us/dn
intlong/html/longhornch04.asp
The options of using NTFS will still be possible and that Longhorn
applications using the new WinFS APIs can access data stored either in
WinFS or in NTFS. In addition, Longhorn applications can continue to use
the Win32 API to access data stored in the NTFS file system.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Yes, that is a change that Microsoft recently made. That wasn't the plan at
the time the article was written. At this point WinFS has been pushed back
many years from now and who knows how many more times it will change between
now and then.
--
I hope this helps,
Steve C. Orr, MCSD, MVP http://SteveOrr.net
"Patrick Olurotimi Ige" <ig*@iprimus.com.au> wrote in message
news:ep**************@TK2MSFTNGP12.phx.gbl... Thats true Steve but. But i think according to what i read here at:-
http://msdn.microsoft.com/data/winfs...brary/en-us/dn intlong/html/longhornch04.asp
The options of using NTFS will still be possible and that Longhorn applications using the new WinFS APIs can access data stored either in WinFS or in NTFS. In addition, Longhorn applications can continue to use the Win32 API to access data stored in the NTFS file system.
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mat |
last post by:
Hi,
I have a system that uploads images as BLOBs in a database. I also
have a function that I use to resize uploaded images before saving as
files. I would like to combine these two by resising...
|
by: Al Knowles |
last post by:
I have researched and tried every method I can find for passing a two-page
tif file from a VB6 application to
a web service via XML. These include XMLTextReader.ReadBase64,
Convert.FromBase64,...
|
by: Satish Appasani |
last post by:
Hi:
I have a ASP.NET form with Web layout which I've achieved using panels. In
one of the tab I have a File control to upload Images. When I put a file in
the file control and move to another...
|
by: Brad |
last post by:
I have code which takes an image, uploaded from a web page, and saves it to
a database. Now I want to always resize an uploaded image before it is
saved to the database. My code to resize is...
|
by: RedHair |
last post by:
I'd like to set up a file system for the ASP.NET 2.0 application
to store user-uploaded files, since the members are more than
100,000 people, the basic requirements are as below:
(1) The file...
|
by: Redhairs |
last post by:
In a web farm environment, how to store the user uploading files for future
access?
Store them in db, local file system or centralized file server?
If trying to storing the file in local file...
|
by: myjish18 |
last post by:
Hello,
We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want to disable
automatic storage on entire database and/or disable...
|
by: Jeigh |
last post by:
Hello,
I'm going to start making a script that will allow users to upload a file, then re download it later. I'll basically be doing the following:
- The uploaded file will be given a string of...
|
by: zizi2 |
last post by:
Hi,
I have a webform that uload images as well. The image is uploaded well but the problem arises when the user does not upload any image. I want the form to save nothing for the image_name in the...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |