#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    7
    Rep Power
    0

    Question storing image in oracle 8i


    hi all
    is the storing image to database is good idea or i store them to files/dir.
    if yes, how can i.
    no, why
    thanks
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    121
    Rep Power
    12
    I am not that familiar with Oracle, but what I know about this in MySQL probably transfers over.

    If you are going to store a lot, then it is not a good idea to do it in the database, as the table can get larger then the maximum supported size and cause corruption.

    If you are going to only store a small amount, then it is faster then the files.

    You need to research how much data it can support and make your decision based on that.
  4. #3
  5. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    With Oracle generally there is not a real size limitation, rather getting images from the db will be slower than retrieving them from filesystem. You should store only paths to images in the db, unless you plan to use advanced features, like Oracle Text (for documents, not images).
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    1
    Rep Power
    0
    hi

    how do you go about storing the dir and format in a table in oracle?

    cheers
    riv

IMN logo majestic logo threadwatch logo seochat tools logo