Re: Best way to store images in DB ?

2002-11-27 Thread Stephane Paquette
I've seen several answers to that post but none of them have asked the question : what will you do with the images ? If the images are to be queried a lot then do not store them in the database. Keep them on the OS. In a prevoius life, we've benchmarked our site (www.houra.fr) with images in and

Re: Best way to store images in DB ?

2002-11-27 Thread Connor McDonald
At a very simplistic level: Lots of small things: databases are very good Not many larger things: file systems are very good In your case, then I'd be looking at storing the images in the database hth connor --- oraora oraora <[EMAIL PROTECTED]> wrote: > Guys, > > i have to store 20,000,000

Re: Best way to store images in DB ?

2002-11-27 Thread Justin Cave
At 08:14 PM 11/26/2002, oraora oraora wrote: Guys, i have to store 20,000,000 images of 5k each in DB. which is the best possible way to do it ? I'd vote for interMedia. interMedia image is designed specifically to store images in the database. It may be an extra cost in 8.1.6, but IMHO it

Re: Best way to store images in DB ?

2002-11-26 Thread Arup Nanda
www.proligence.com From: "oraora oraora" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Best way to store images in DB ? Date: Tue, 26 Nov 2002 19:14:20 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68

Best way to store images in DB ?

2002-11-26 Thread oraora oraora
Guys, i have to store 20,000,000 images of 5k each in DB. which is the best possible way to do it ? can i store it as BLOB or use UTL_FILE_DIR ? is there any other means of achieving the same ? it's 8.1.6 on Win2k. Kindly let me know. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://ww

Best way to store images in DB ?

2002-11-26 Thread oraora oraora
Lee, i have to store 20,000,000 images of 5k each in DB. which is the best possible way to do it ? can i store it as BLOB or use UTL_FILE_DIR ? is there any other means of achieving the same ? it's 8.1.6 on Win2k. Kindly let me know. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www