Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Location
    UAE, abu dhabi
    Posts
    4

    Question Unanswered: Storing images in the database???

    hello ... i have a project this semester and i had to study is storing images in a database ( using Microsoft Access ) is good or bad ? so any one could tell me the advantages and the disadvantages please ...
    thanks
    bye

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Take help of this KBA http://support.microsoft.com/default...NoWebContent=1 to accomplish the task.

    In general its not recommended to store images directly on the database for sizing purposes, store the path of the image on the disk.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Sep 2004
    Location
    UAE, abu dhabi
    Posts
    4

    Cool

    Thanks a lot satya for replying on my thread ... but what i need is to know the advantages and the disadvantages for this method, storing images in database, that's what i want ... and thanks for replying on my thread ...

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Don't store your web page images in a database using SQL Server's image data type, it is much too slow. The image data type should generally be avoided because of its poor performance.

    Whenever you need to dynamically create a page with images, your code can retrieve the URLs of the images and then insert the URLs into the page as it is dynamically created. When the page is displayed in a visitor's web browser, the images are retrieved directly from your web server.

    This way, you have the advantage of managing image information in a database, but you don't have the overhead of storing the actual image in the database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Sep 2004
    Location
    UAE, abu dhabi
    Posts
    4

    Thumbs up

    thank you Satya you helped me soo much ... now i get the idea of storing the images ...

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I wounder if Yukon merged the file server concept in with data storage to simplify this process...didn't they roll back some features...or was that just whidbey?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •