Re: Experience wanted: low-cost Photo-Archive in TB range

W liście z pią, 28-11-2003, godz. 13:51, Oli Sennhauser pisze:
> Hello
>
> We are planning and offering a low-cost Photo-Archive in TB range. Is
> there any experience available with that amount of Data (1-3 TB)?
> What kind of machines (CPU, RAM)? What kind of I/O-System? What kind of
> Network (100Mbit Ethernet, Fibre, etc.).
> What kind of backup-system? How to backup that amount of data, etc.

Well, you want to keep pictures inside database, as a blobs. Maybe it
would be better to hold pictures on disk, on hashed directories ( eg
spring_picture.jpg as a s/p/r/i/spring_picture.jpg faster access when
there is a lot of files ) and in the database hold only file_path to
this images, and some other data. Then file_path would be taken from
database, written to html page, and the image would be taken from disk.
Would it be fast enough, and less demanding from database and machine ?

greetings
Marek

>
> Any comment is welcome!
>
> Regards Oli
>
> -------------------------------------------------------
>
> Oli Sennhauser
> Database-Engineer (Oracle & PostgreSQL)
> Rebenweg 6
> CH - 8610 Uster / Switzerland
>
> Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
> e-Mail oli(dot)sennhauser(at)bluewin(dot)ch
> Website http://mypage.bluewin.ch/shinguz/PostgreSQL/
>
> Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch
>
> Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import
>