Storing Images


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Storing Images

  1. #1
    Puneet Puneet_dh Guest

    Storing Images


    Hi Bill,
    I have to store Images In my database,Since number of files to store could
    be ranging from one to lacks.
    How can ADO help me in faster retreival of image from SQL Server?
    I have files in Tiff format.
    Regards

    Puneet Dhawan
    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: Storing Images


    I'm not a fan of storing BLOBs (binary large objects) such as pictures in
    the database. The file system is far better suited for this and can retrieve
    selected files far, far faster and easier. There are examples of BLOB handling
    AppendChunk, GetChunk and when these are needed and how to best handle them
    in my book.

    bv

    "Puneet" Puneet_dh wrote:
    >
    >Hi Bill,
    >I have to store Images In my database,Since number of files to store could
    >be ranging from one to lacks.
    >How can ADO help me in faster retreival of image from SQL Server?
    >I have files in Tiff format.
    >Regards
    >
    >Puneet Dhawan


    Share on Google+

  3. #3
    Eric Ford Guest

    Re: Storing Images


    Bill,

    I overheard a comment from another developer on Sql Server that storing
    BLOBs and/or Text fields interferes with or disables transaction logging
    until the next full backup is performed. Can you confirm or dispel that
    assertion?

    "Bill Vaughn" <billva@microsoft.com> wrote:
    >
    >I'm not a fan of storing BLOBs (binary large objects) such as pictures in
    >the database. The file system is far better suited for this and can retrieve
    >selected files far, far faster and easier. There are examples of BLOB handling
    >AppendChunk, GetChunk and when these are needed and how to best handle them
    >in my book.
    >
    >bv
    >
    >"Puneet" Puneet_dh wrote:
    >>
    >>Hi Bill,
    >>I have to store Images In my database,Since number of files to store could
    >>be ranging from one to lacks.
    >>How can ADO help me in faster retreival of image from SQL Server?
    >>I have files in Tiff format.
    >>Regards
    >>
    >>Puneet Dhawan

    >


    Share on Google+

  4. #4
    Bill Vaughn Guest

    Re: Storing Images


    SS changes all the time. I was under the impression that BLOB operations were
    logged so they would consume a great deal of space (potentially). This might
    have changed (I doubt it)--but I'm not sure. The best way to avoid this problem
    is to keep BLOBs out of the database. Save pointers to the BLOBs stored as
    files elsewhere (on CD if they are RO).

    bv
    "Eric Ford" <Eric_S_Ford@hotmail.com> wrote:
    >
    >Bill,
    >
    > I overheard a comment from another developer on Sql Server that storing
    >BLOBs and/or Text fields interferes with or disables transaction logging
    >until the next full backup is performed. Can you confirm or dispel that
    >assertion?
    >
    >"Bill Vaughn" <billva@microsoft.com> wrote:
    >>
    >>I'm not a fan of storing BLOBs (binary large objects) such as pictures

    in
    >>the database. The file system is far better suited for this and can retrieve
    >>selected files far, far faster and easier. There are examples of BLOB handling
    >>AppendChunk, GetChunk and when these are needed and how to best handle

    them
    >>in my book.
    >>
    >>bv
    >>
    >>"Puneet" Puneet_dh wrote:
    >>>
    >>>Hi Bill,
    >>>I have to store Images In my database,Since number of files to store could
    >>>be ranging from one to lacks.
    >>>How can ADO help me in faster retreival of image from SQL Server?
    >>>I have files in Tiff format.
    >>>Regards
    >>>
    >>>Puneet Dhawan

    >>

    >


    Share on Google+

Similar Threads

  1. storing images in access using Vb.net
    By paksmanzoor in forum .NET
    Replies: 1
    Last Post: 03-31-2005, 10:16 AM
  2. Storing and displaying images in Access database
    By Shravan in forum VB Classic
    Replies: 1
    Last Post: 04-27-2002, 12:31 PM
  3. storing images
    By ravi in forum XML
    Replies: 1
    Last Post: 08-07-2001, 10:48 AM
  4. Replies: 2
    Last Post: 03-02-2001, 11:57 AM
  5. Storing Images in MSSQL 2000
    By Rudy Panigas in forum authorevents.vieira
    Replies: 1
    Last Post: 01-25-2001, 01:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center