Upload image to database

4 posts, 0 answers
  1. Iosu Buenetxea
    Iosu Buenetxea avatar
    91 posts
    Member since:
    Jan 2008

    Posted 27 Apr 2010 Link to this post

    Hi there,

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

    Thanks!
  2. Ivan
    Admin
    Ivan avatar
    519 posts

    Posted 30 Apr 2010 Link to this post

    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.
  3. DevCraft banner
  4. Mac P
    Mac P avatar
    84 posts
    Member since:
    Mar 2010

    Posted 02 Jun 2010 Link to this post

    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?
  5. Valentin.Stoychev
    Admin
    Valentin.Stoychev avatar
    2198 posts

    Posted 03 Jun 2010 Link to this post

    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.
Back to Top