| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: image storage confusion ??
oraora
I've provided a couple of thoughts before in response to this issue, but
I think that the only way you will get a satisfactory answer is to code a
simple test. I hope someone else has extensive experience with 5k images and
will reply to you. However, I think the answer to your question will vary
quite a bit, depending for example on image size. The experience of someone
based on 50k images, for example might not give you a good result. The
answer may also depend on the operating system itself. The fact that you are
using Java for access may also make a difference compared other languages. I
think that you are going to have to code it both ways and run a few tests.
If performance is really, really important to your company, you are probably
going to be testing quite a few programming alternatives.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, December 03, 2002 4:49 AM
To: Multiple recipients of list ORACLE-L
Guys , i posted this already and this time my question is a bit different .
I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system.
the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum.
for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ?
--selecting a file from linux o/s file system -------
or
--querying it from oracle DB ( on win2k) ---------------
which of the above will be faster ?
all these will be done with java . this being condition , i
would
like to know ur suggestion guys.
my DB is oracle 8.1.6 on Win2k.
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: oraora oraora
INET: oraoraora_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 03 2002 - 08:32:25 CST
 |
 |