SQL Server Performance

Loading Images Faster

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by PAMUR, Sep 15, 2005.

  1. PAMUR New Member

    Dear All,


    We are using VB.Net and SQL SERVER, All Images are stored in Binary. But loading them on a page is taking time. How do I load them faster?

    Kindly suggest me.
    Thanks

    Usha Rani
  2. Madhivanan Moderator

    How about storing the File path than storing image itself?
    All you need is to use FileSystem object to retreive image from the directory

    Madhivanan

    Failing to plan is Planning to fail
  3. PAMUR New Member

    Will this give adequate performance? Won't storing in DB gives better performance?

    Just clearing my thought. Do let me know.

    Thanks

    Usha Rani
  4. Madhivanan Moderator

    I think It is better to store the file path than using image column
    You need to use GetChunk and AppChunk methods to store and Retreive image if you stored image itself


    Madhivanan

    Failing to plan is Planning to fail
  5. PAMUR New Member

  6. satya Moderator

    Using GetChunk method with VB is suggestable, but on the basis of databsae management it is better to store the filepath and use the file server to store images on operating system.

    This has been discussed many times in the forum and if you're comfortable with your current approach, then continue. Image data can get a bit messy if you run into problems on the server. If you had to have a torn page, you will lose a considerable amount of data.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. FrankKalis Moderator

    If you have time read this
    http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
    completely. It's a very good discussion on BLOBs in general. If not, just scroll down to the bottom. There you'll find some code snippets.
    Also
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;194975
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  8. PAMUR New Member

    I have not been in touch for a long time. Thanks to all of you. Thae links have provided me with good insight.

    Thanks once again.
    Usha Rani

    Usha Rani

Share This Page