This is a migrated thread and some comments may be shown as answers.

Upload image to database

3 Answers 159 Views
Upload
This is a migrated thread and some comments may be shown as answers.
Iosu Buenetxea
Top achievements
Rank 1
Iosu Buenetxea asked on 27 Apr 2010, 11:07 AM
Hi there,

Is there any way to upload an image to database (Sql Server) using RadUpload?

Thanks!

3 Answers, 1 is accepted

Sort by
0
Ivan
Telerik team
answered on 30 Apr 2010, 12:13 PM
Hello Juan,

Thank you for contacting us.

Please follow the pattern in the RadUpload ChunkTag or how to deal with uploaded files by chunk article. There is an example too. Please give it a try and let us know if you need further assistance.

We hope this information will help you.

Sincerely yours,
Ivan
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Mac P
Top achievements
Rank 1
answered on 02 Jun 2010, 05:32 PM
I have requirement to store large documents(50mb to 1gb) to sql server 2008 R2 in a column that is of filestream type.
Is it a good idea to store the entire file on server using silverlight upload and than stream it back to sql server database or stream chunks to database directly as you suggested in your article.

How will it perform regarding fragmentation and how will it work in case of webfarm scenario?
0
Valentin.Stoychev
Telerik team
answered on 03 Jun 2010, 11:03 AM
Hello Mac P,

we haven't tested this scenario and we can't tell you which will be more performant. The thing with performance is that it should always be measured - I can recommend you to test the both cases. I believe that if you write to DB directly will be faster, but it could expose a problem - if the user closes the browser while the file is still not uploaded successfully you will end up with a partly stored file in DB and it may be a problem for your application.

About the webfarm - if you have multiple SQL servers - yes it will be a problem. If you have a single sql server it should be ok.

All the best,
Valentin.Stoychev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Upload
Asked by
Iosu Buenetxea
Top achievements
Rank 1
Answers by
Ivan
Telerik team
Mac P
Top achievements
Rank 1
Valentin.Stoychev
Telerik team
Share this question
or