image size [message #567558] |
Wed, 03 October 2012 05:29 |
hisham99
Messages: 106 Registered: October 2008 Location: united arab emirates
|
Senior Member |
|
|
i have Archive project for hr
create table images
(ID number(,
IMAGES BLOB);
i have a form that scan and save the image in database ,all the image size is A4, JPG
i have this question
1)what will be the estimated size of A4 JPG image in database,because i dont want my hard disck to be full.
2)what is the best way to decrease the size of each picture to minimum.
3)which type is beter for image blob or long raw.
4)when i try query from sql for example (select * from images)
it give me this erro ('Column or attribute type can not be displayed by SQL*Plus');
5) is theres any query i can used to know the size of image in each raw (bytes or mb,..)from my table.
thanks
|
|
|
|
Re: image size [message #567629 is a reply to message #567559] |
Wed, 03 October 2012 12:28 |
hisham99
Messages: 106 Registered: October 2008 Location: united arab emirates
|
Senior Member |
|
|
from your experence ,i saved one image in my table and
i used select dbms_lob.getlength
and it give me this number 7633955 (this number is only for one image)
from your point of view is it practical to save image in the database i mean is this size is acceptable i dont want after saving few image the program become slow or my table space become full
|
|
|
Re: image size [message #567645 is a reply to message #567629] |
Wed, 03 October 2012 23:57 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I keep my images in file system (i.e. I don't store them in the database). I can't tell what would be better for you; the answer might depend on number of images (dozen, hundred, thousands, ...?).
|
|
|