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 [EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
