Best way to store pictures
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Best way to store pictures

  1. #1
    Join Date
    Nov 2000
    Posts
    173

    Best way to store pictures

    Hi,

    We are getting an application that will have approx. 1200 pictures.

    What would be the best way to store them?

    Thanks,
    Kathy

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Talking



    Use a BLOB.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2000
    Posts
    173
    What do you think the performance and storage requirements would be in comparing a blob to a bfile (external file)?
    Last edited by kburrows; 07-30-2007 at 02:41 PM.

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    There is no free lunch and you "may" notice some performance overhead with keeping them in the database. You should really do some performance benchmarks on your system to evaluate each method. Good thing about keeping them in the database is Backup & Recovery and Security.

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by kburrows
    We are getting an application that will have approx. 1200 pictures.
    My personal opinion is twelve hundred pictures is not such a big deal in terms of space and management meaning; you can do it either way.

    In our shop we have an application that gets about six thousand pictures a day. We are storing pictures as external files keeping just an address reference in the database, the rationale behind it is: pictures are already stored in a disk, why bother in loading them into the database when what Oracle is gonna do is to stored them as blob segments -the way Oracle stores data "outside" the database.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Apr 2006
    Posts
    377
    As was mentioned, a benefit of storing them IN the database is seamless Backup & Recovery and the security aspects that can be provided by the database.

Posting Permissions

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



Click Here to Expand Forum to Full Width