| Storing image in database [message #385813] |
Wed, 11 February 2009 03:24  |
atulwagh
Messages: 18
Registered: June 2007
Location: Mumbai
|
Junior Member |
|
|
Hi,
I want to store image in database.
There are usually two approaches for that:
1]The data is stored in the database as LOB fields (BLOB for binary and CLOB for character data),
2] in OS files with the references to the files stored in the database.
Can anyone tell me which one is better??
Thanks & Regards,
Atul
|
|
|
|
| Re: Storing image in database [message #385817 is a reply to message #385813] |
Wed, 11 February 2009 03:32  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If one of them was strictly better than the other, then only one would exist.
Storing them in the Db means that your images will be backed up, and are more secure, but they can only be accessed via the Db. It may well also adversely affect your backup times if you have a large volume of images.
Storing them as Bfiles means they are less secure, but can be accessed other than via the Db.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
