SQL Server Performance

Insert images to SQL Server

Discussion in 'General Developer Questions' started by pcsql, Jun 14, 2005.

  1. pcsql New Member

    I want to get some suggestions how to resolve the following scenario.

    I have some images which stored in a folder of the server in which the SQL Server 2000 is running. In a LAN environment, I can map to the server and retrieve images and connect to the SQL Server through ODBC. However, in a remote access environment, I can still connect to the SQL Server through ODBC using TCP/IP but I cannot map to the server and retrieve images. Should I just store the images into the SQL Server image column?

    Besides this linkhttp://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-
    us/part3/c1161.mspx, are there any articles/webcasts I should check out before using image column?


  2. Madhivanan Moderator

    Did you store the path of the images and retreive them? That would be simple method


    Failing to plan is Planning to fail
  3. dineshasanka Moderator

  4. ghemant Moderator

    Yes sir,
    it is advisable to store the path of Image folder rather storing images into the column, before we used to store images into the DB but it would effect performance and then we store the path of image and now we are satisfy.

  5. FrankKalis Moderator

    Read the link. It is the by far most complete discussion on that topic I've found so far. The topic tends be frequently discussed and almost always this ends up in heated discussions. The article gives arguments for both approaches in a very neutral way. Other links, webcasts? None of importance, I'm aware of. But make sure, you read closely through the article. And you can also have a look at the implementation at Terraserver.

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

    Images are saved in server folder and i want to retreive them throught reference of sql 2005.
    So please can you tell me how can i save reference in sql and retrieve the same in Datalist control.
  7. makjain New Member

    PLz reply to my post, its urgent to me
  8. Adriaan New Member

    Good to see that you did a search before you posted. However, you ended up in a section for the 7.0 and 2000 versions of SQL Server.
    Also, your questions seems to relate more to Reporting Services, so I would suggest that you re-post there.

Share This Page