SQL Server :: File System Better Than Sql Server For Video Storage?
Nov 6, 2010
Currently, I am storing images and video clips in my database as a varbinary(max).
The problem is that when my front-end goes to retrieve and play the video, it takes an excessive amount of time to download.
For example, I have a video file: test.avi (5mb). If I attempt to read from database and play avi, it takes about 40 seconds. If I attempt to play this test.avi from the filesystem, it takes about 10 seconds to load.
I have investigated compression/decompression, but those seem to be as time-consuming as just loading up the raw data from the database.
Should I scrap storing video clips in the database, and go for a file system approach. I would really like to keep everything clean, secure, and organized. Which is why I am storing images, video clips, etc. in database.
What is the best approach to storing images in a file system. Currently I am separating the images by day, month and then year. I am also hashing file name so that no two files will be stored with the same name. Lastly, how would I go about using the image file address in a forum?
i have a folder on the server which contains jpeg files,mp4 files and also xml files...........
i would like to transfer the folder to a centralised storage server ,i would like to pass the credentials from the web page itself,,,,,,,,
what do i use for it
the storage server is within the network and all it needs is credentials to copy the folder which i m ready to pass....but i dont know the code which has to be used......
i am doing an task about uploading & retrive video file in asp.net. first of all tell me How Can we Upload Video files In sql server? then second one is How Can we displays that uploaded video files in my web page?
I have a web site that you can upload images, the image path is saved in the ImgPath field in the data database and retrieves the image and displays it in the grid view. I want to be able to delete the image from a folder within my project when I delete the record. I'm trying to delete it from the Detailsview_ItemDeleting event.
the file is being saved on the server & needs to be same on the local system too so used the above code but the actual size is nt being saved on the local system if the file size on server is 3 MB in local system i gets saved in kbs
I maintain a web application (ASP.NET/IIS7/SQL2K8/Win2K8) that needs to access documents, actually hundreds of thousands of documents, and growing. Currently, they are all on a Windows 2K8 Server fileshare, being accessed by UNC path (SMB). The files are in a single flat directory and I'm trying to plan how to best improve this solution. I don't want to use the SQL Filestream attribute as it would be significant effort to migrate it all into that, and would really lock in to SQL Server. I also need to find a way to replicate the data for disaster recovery, so perhaps a solution can help with that too. Options could be: Segment files into multiple directories? application would add metadata for which directory it's on (or segment by other means) Segment files into separate servers? (virtualize)Backup becomes more complicated. Application would add metadata for which server it's on
NAS Storage SAN Storage
Put a service (WCF) in front of the files and have the app talk to the service bonus of being reusable across many applications Assuming I'm going to store on filesystem and not in database (I've read those disccusions here), which would be a more scalable solution?
Created a new virtual directory on my web sit in IIS 6.. set proper settings and wild card extensions... published via file system from dev environment to the server but i get a page cannot be found 404 error when browsing the site...
i am new to technology so go easy on this post according to what i read from web there are 3 type of custom server controls 1 superclass2 composite 3 renderedi found video tutorial for superclass custom server control but couldnt find video tutials for other 2.lease forward me link for composite and rendered custom server controls video tutorial
I had this one working a while back i try to upload file to my root folder it works locally but when i try it from my website i get the following error: exception details: system.bet .webexception. unable to connect to the remote server
the code bomb at the following line
requestStream = uploadRequest.GetRequestStream() 'This is where the exception occurs fileStream = File.Open(localFile, FileMode.Open) [code]....
<identity impersonate="true" userName="webserverloginname" password="webserverpassword" /> sername1= username of the system password1 = passowrd of the system username2= username of the the database password2 = passowrd of the database
client system which access the database server aswell as web server
In machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
which edition of sql server are best for me Developer edition or express editon for development purpose.i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.
I have a problem, I have created a website that is run on local host database is make in 2005 sql server
now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working
problem gives "NT NETWORK SERVICE FAILED "
how we can convert the sql 2005 mdf file to sql 2008 file.
I would like to be able to give my users the ability to securely upload and store files, sometimes upwards to about a gigabyte in size. I'm not quite sure what's the best way to go about doing this. I would like to have the connection between the client and the server secured, so I'm sure I will probably have to use SSL. Now, my major crux is secure storage. Being that the data is somewhat sensitive, I'm wondering if I should encrypt the file before it is stored. I guess my question is, should I open the file and encrypt each byte or encrypt the file as a whole. I'm assuming that the latter is the better option. I know that there are a number of examples of how to encrypt a file using a number of different methods (aes, des, md5 (hashing not really encrypting), etc). Currently, to encrypt text, I am using the Rijndael algorithm, sha1, 256 bit keys, a predefined passphrase, salt value, and IV.
I'm currently developing a web application whose primary user function is uploading and downloading of files. The files will be stored on the hard disk (no cloud storage yet).
Taking into consideration the possibilities of gigabytes of data and a large number of files, do I need to organize files into sub folders to account for the fetching of a file or is the file system's indexing already very efficient and I can ignore this potential bottle neck?
Update:
On a side note, I plan to store file names and any additional information in a SQL database and only query the disk when a user actually wants to download the file. This is how I plan on retrieving files:
I am a Bigner in asp.net c# learning. How can i create a new folder in server from my c# program. in my semester asp.net project, i want to upload video/audio files into my own newly created folder and the storing folder's name must be given by me, which means each time folder name may change during uploading time. and how can i give a picture link to that vodeo files containing in different folders and how can i play that files in the browser using a player.
I am working on an Entertainment Website, my client wants to save videos in the database, i am a bit aware of silverlight, that it can be done through microsoft's silverlight platform.
how to accomplish my goal, i am using ASP.Net with C# and LINQ and backend in MS-SQL Server 2008.
