You should/must do a benchmark.
If not, how can you justify your decision ?
If your management do not ask for a benchmack then you
have bad management (and that's no good for you
either...)
Anyway, in a previous life, we did a benchmarck with
files of similar size and it was faster on the OS.
The environment was Oracle 816/Sun with Vignette Story
Server.
HTH
- oraora oraora <oraoraora_at_rediffmail.com> a écrit
: > 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).
>
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Stephane=20Paquette?=
INET: stephane_paquette_at_yahoo.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).
Received on Tue Dec 03 2002 - 08:32:23 CST