CODEWITHSUNDEEP
c#asp.netsql-server
Peyush
Peyush

Reputation: 1

Efficient way to upload files

I have a aspx webpage where there's an option to upload multiple files.These files have to be stored in the database in BLOB format. What will be the most efficient manner to store these files? There's no constraint on the size or number of file to be uploaded. Should I upload the files one by one whenever the user clicks the file upload button or upload them once simultaneously when the whole form gets submitted on save button. Please keep in mind, this is to used by multiple users about ~1000 at a time

Upvotes: 0

Views: 350

Answers (3)

Tigran
Tigran

Reputation: 62246

Considering that it is a BLOB data, I would consider to use some No-SQL database (MongoDB, RavenDB), where you save just "document" with data, so it's easier to manage in these kind of situations. But you will need more disk space in this case.

What about upload: I would go one after one, as in case if connection drops, at least some of the files are delivered.

On the server side, would look on Redis like in memory cache that always ready to accept user "session" (a sequence of declared quantity of files), and one time all of them delivered, or connection failure the content of that session is saved on the disk.

Just general overview what can be done to give you some hints.

Upvotes: 1

Neil Thompson
Neil Thompson

Reputation: 6425

Given the limitations of your scenario (where the images must be stored in (I assume) a single SQL Database) I would look into uploading the images one by one, and I would investigate if the SQL Server Transient Fault Handling with the Exponential back-off strategy could help to try and handle the 'queued' uploads.

Without more details I can't really say.

Upvotes: 0

Banana
Banana

Reputation: 7463

set file upload control multiple attribute to 'multiple' and in the code behind get request user submitted files, then loop through their memory stream and store them in your db as byte arrays

Upvotes: 0

Related Questions