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.

View 4 Replies


Similar Messages:

Image Storage And Retrieval In File System?

Jan 11, 2010

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?

View 3 Replies

Send Files From A Server To A Storage Server On The Same Network?

Oct 18, 2010

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......

whether to use system.io.move

or

httpwebrequest.

View 10 Replies

SQL Server :: How To Upload Video File In Database

Dec 4, 2010

upload the vedio file in sqlserver database using asp.net c# .

View 4 Replies

Web Forms :: Uploading & Retrieve Video File From Sql Server

Aug 7, 2010

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?

View 3 Replies

Custom Server Controls :: Require Video Tutorial For Composite Server Control And Rendered Server Control?

Aug 20, 2010

according to what i read from web there 3 types of custom server controls

1. composite

2.superclass

3.rendered

i found video tutorial to create and use superclass custom control in your project (extending dropdown control functionality)

i am trying to search video tutorial for other 2 types .

View 1 Replies

SQL Server :: Delete Image File From File System

Oct 9, 2010

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.

View 4 Replies

SQL Server :: Data Type Of Storage Used For Male And Female?

Mar 10, 2011

What data type of storage used for male and female?

View 2 Replies

Web Forms :: File Size Saved On Local System Is Not Same As The Server?

Mar 6, 2010

i have file

Response.Clear()
Response.ContentType =
"application/octet-stream"
Response.AddHeader(Response.WriteFile(M_FILENAMe, "Content-Disposition", _"attachment; filename=""" & M_FILENAMe & """")True)Response.Flush()
Response.End()

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

View 3 Replies

How To Scale Document Storage System

Feb 1, 2011

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?

View 1 Replies

MVC :: Publishing Via File System From Dev Environment To The Server - "Page Cannot Be Found

Jul 16, 2010

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...

View 4 Replies

How To Get A Basic System That Uploads A File To The Server And Stores The Details In A Database

May 7, 2010

I need a basic system that uploads a file to the server and stores the details in a database, with the ability to add/ edit/ delete whats there.

Most of the solutions I've seen have been far to indepth. I'd like something very simple so I can pick it apart and modify it.

View 4 Replies

Custom Server Controls :: Video Tutorial Link For Composite And Rendered Custom Server Control?

Aug 20, 2010

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

View 1 Replies

File Upload Error/exception Details: System.bet .webexception. Unable To Connect To The Remote Server

Mar 2, 2010

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]....

View 2 Replies

Security :: Client System Which Access The Database Server Aswell As Web Server

May 10, 2010

in its webconfig file i have

<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

View 2 Replies

SQL Server :: SQL SErver 2005 Express Edition Installation & System Restting (10000 Times)?

Jan 12, 2011

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

View 2 Replies

SQL Server :: Take DataBase Backup From Remote Server To Local System?

Dec 16, 2010

i want to take the DB Backup from theremote server to the local system..

i'm using sql server2008 enterprise edition and the remote server is sql server2008 express. how to do it..

View 3 Replies

SQL Server :: Unable To Install Sql Server In System?

Aug 20, 2010

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.

View 7 Replies

DataSource Controls :: Importing Xml File Into Sql Server (.sdf) With Mapping File (Sql Server Compact Edition)?

May 10, 2010

I have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).

View 2 Replies

DataSource Controls :: How To Convert The Sql Server 2005 File To Sql Server 2008 File

May 24, 2010

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.

View 2 Replies

How To Secure File Transfer And Storage

Feb 21, 2011

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.

View 2 Replies

C# - Developing A File Storage Web Application?

Aug 5, 2010

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:

FileStream stream = File.Open("C:file.txt");
byte[] fileContent = new byte[stream.Length];
stream.Read(fileContent, 0, fileContent.Length;

Any file information will be retrieved from the database. The hard disk will only be used for saving and fetching files.

Update 2:

Files will be saved as GUID + EXTENSION on the hard disk while the actual file name is stored in the database.

View 4 Replies

DataSource Controls :: Play Video From Sql Server To Flash Player Using C#

Mar 31, 2010

I uploaded video in sql-server by using codeproject [URL[ article.this is working fine. Now I want to play this video in flash player like youtube.

how to play video from sql-server to flash player.

View 2 Replies

Web Forms :: Creating New Folder In Server And Video / Audio Uploading And Playing

Oct 15, 2010

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.

View 1 Replies

DataSource Controls :: Save Video Files In Sql Server Using C# / Linq And Silverlight?

Apr 5, 2010

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.

View 7 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved