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. [EMAIL PROTECTED]
-----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).