DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Best way to store pictures

  1. 07-30-2007, 02:01 PM #1
    kburrows
    kburrows is offline Member
    Join Date
    Nov 2000
    Posts
    175

    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
    Reply With Quote Reply With Quote
  2. 07-30-2007, 02:13 PM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking



    Use a BLOB.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  3. 07-30-2007, 02:37 PM #3
    kburrows
    kburrows is offline Member
    Join Date
    Nov 2000
    Posts
    175
    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.
    Reply With Quote Reply With Quote
  4. 07-30-2007, 06:39 PM #4
    ebrian
    ebrian is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  5. 07-31-2007, 07:48 AM #5
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
    Reply With Quote Reply With Quote
  6. 07-31-2007, 02:14 PM #6
    ebrian
    ebrian is offline Senior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width