September 16th, 2003, 12:34 AM
storing image in oracle 8i
is the storing image to database is good idea or i store them to files/dir.
if yes, how can i.
September 16th, 2003, 12:39 AM
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.
September 16th, 2003, 04:11 AM
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).
October 18th, 2003, 04:34 PM
how do you go about storing the dir and format in a table in oracle?