Iosu Buenetxea
Top achievements
Rank 1
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!
Is there any way to upload an image to database (Sql Server) using RadUpload?
Thanks!
3 Answers, 1 is accepted
0
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.
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
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?
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
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.
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.